BenchMark Quizzes by MDFT Pro

Use Role-Playing Dimensions In Power BI

You have a Power BI data model at MDFT Pro with multiple date relationships. The academy tracks both order and shipping dates for each sale, and you want to analyze sales by ShippedDate instead of the default OrderDate.

Which function should you use in your DAX measure to activate the correct relationship for your analysis?

Choose the correct answer from the options below.

Explanations for each answer:

USERELATIONSHIP is correct. USERELATIONSHIP activates an inactive relationship for a calculation, allowing you to slice data by a different date column.
CROSSFILTER is incorrect. CROSSFILTER changes the cross-filter direction but it does not activate an inactive relationship.
RELATED is incorrect. RELATED returns a related value from another table, it does not activate an inactive relationship.
RELATEDTABLE is incorrect. RELATEDTABLE evaluates a table expression in a modified context, it does not activate an inactive relationship.

Learn more about USERELATIONSHIP in Power BI:

Power BI USERELATIONSHIP Function

Exam Preparation Quiz

Use Role-Playing Dimensions In Power BI