Exam PL-300 topic 2 question 122 discussion

Actual exam question from Microsoft's PL-300

Question #: 122
Topic #: 2

DRAG DROP
-

You have a Power BI semantic model that contains two tables named Dim Location and Fact Deliveries. The relationships between the tables are configured as shown in the following table.

The model contains one measure that has the following formula.

Deliveries = COUNTROWS(‘Fact Deliveries’)

You need to create a new measure that counts the number of deliveries based on the destination location.

How should you complete the DAX expression? To answer, drag the appropriate functions to the correct targets. Each function may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by a2c7cd3 at June 13, 2025, 12:08 p.m.

Comments

Submit Cancel

a2c7cd3

Highly Voted 1 month, 3 weeks ago

Use CALCULATE and USERELATIONSHIP. The measure [Deliveries] returns a single integer value, not a table, so CALCULATE is correct, not CALCULATETABLE.

upvoted 5 times

...

Lulu_2022

Most Recent 1 month ago

✅ Explanation: CALCULATE: Changes the filter context to evaluate [Deliveries] under a new relationship. USERELATIONSHIP: Temporarily activates an inactive relationship between Location[Location ID] and 'Fact Deliveries'[Destination Location ID]. This is commonly used when you have multiple relationships between two tables (e.g., one for origin and one for destination), and you want to explicitly activate the one for destination in a specific measure.

upvoted 1 times

...