Q: 17
DRAG DROP You have a Power B1 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') 
Drag & Drop
Discussion
Deliveries by Destination = CALCULATE ([Deliveries], USERELATIONSHIP. This combo lets you activate that inactive destination relationship on the fly. I think that's the intended approach here, since only CALCULATE plus USERELATIONSHIP will do it in one go. If anyone thinks ALLSELECTED fits instead, let me know.
CALCULATE maps to the measure and USERELATIONSHIP as the filter argument. This is classic Power BI behavior, similar pattern shows up in lots of exam dumps. Still bugs me that Microsoft keeps reusing these relationship questions, wish they'd mix up the scenarios more.
Deliveries by Destination = CALCULATE, ([Deliveries], USERELATIONSHIP. Only works this way since the destination relationship is inactive.
Deliveries by Destination = CALCULATE, ([Deliveries], USERELATIONSHIP. Fit for activating that inactive relationship, pretty sure it's right here.
Pretty sure it's ALLSELECTED and CALCULATETABLE for this one. Practice questions and the official guide should cover patterns like this.
Be respectful. No spam.
