PL-300 practice question 22 of 35

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that…

Choose your answer, then check it against the explanation.

Domain Visualize and analyze the data

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a Power BI model that contains two tables named Sales and Date. Sales contains four columns named TotalCost, DueDate, ShipDate, and OrderDate. Date contains one column named Date. The tables have the following relationships: Sales[DueDate] and Date[Date] Sales[ShipDate] and Date[Date] Sales[OrderDate] and Date[Date] The active relationship is on Sales[DueDate]. You need to create measures to count the number of orders by [ShipDate] and the orders by [OrderDate]. You must meet the goal without duplicating data or loading additional data. Solution: You create measures that use the CALCULATE, COUNT, and USERELATIONSHIP DAX functions. Does this meet the goal?

Answer options

Correct Answer:

Explanation

The proposed solution is correct. In Power BI, when multiple relationships exist between two tables, only one can be active at a time. To perform calculations based on an inactive relationship, the USERELATIONSHIP DAX function is required. This function must be used within a CALCULATE function to modify the filter context for that specific calculation. By creating measures like CALCULATE(COUNT(Sales[column]), USERELATIONSHIP(Sales[ShipDate], 'Date'[Date])), you can count orders by ShipDate and OrderDate while the active relationship on DueDate remains the default for other visuals. This approach meets the goal without altering the data model or loading duplicate data.

Why Incorrect

B. No: This is incorrect. The combination of CALCULATE, COUNT, and USERELATIONSHIP is the standard and correct DAX pattern to activate an inactive relationship for a specific measure, which directly solves the stated problem.

References

1. Microsoft Documentation

"USERELATIONSHIP function (DAX)": "Specifies the relationship to be used in a specific calculation... It is used within functions that take a filter as an argument

such as the CALCULATE... functions. This is the recommended way to override the default

active relationship in calculations that need to refer to inactive relationships."

2. Microsoft Learn

"Create model relationships in Power BI Desktop": Under the section "Active vs inactive relationship

" it states

"If you want to use an inactive relationship in a specific calculation

you can use the USERELATIONSHIP DAX function."

3. Microsoft Learn

"Apply DAX basics in Power BI Desktop": In the unit "Use CALCULATE() to modify the filter context

" it explains how CALCULATE is essential for complex calculations that alter the context

which is precisely what USERELATIONSHIP does. The example provided in the documentation for USERELATIONSHIP uses CALCULATE to demonstrate its usage.

Question 22 of 35

Keep practicing

Take the free PL-300 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test