What should you recommend?

You have a data model that contains many complex DAX expressions. The expressions contain frequent references to the RELATED and RELATEDTABLE functions.

You need to recommend a solution to minimize the use of the RELATED and RELATEDTABLE functions.

What should you recommend?
A . Merge tables by using Power Query.
B . Hide unused columns in the model.
C . Split the model into multiple models.
D . Transpose.

View Answer

Answer: A

Explanation:

Combining data means connecting to two or more data sources, shaping them as needed, then consolidating them into a useful query.

When you have one or more columns that you’d like to add to another query, you merge the queries.

Note: The RELATEDTABLE function is a shortcut for CALCULATETABLE function with no logical expression.

CALCULATETABLE evaluates a table expression in a modified filter context and returns A table of values.

Reference: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data