Question 360
A measure must activate an existing inactive date path rather than simulate it with arbitrary text comparisons. Which implementation best addresses this scenario?
Explanation
Correct Answer
USERELATIONSHIP leverages the existing relationship with known date keys. It meets the scenario requirement of efficient alternate physical relationship.
Incorrect Answers
Virtual relationships transfer intended filter values without changing the physical model. It would instead address calculation-specific disconnected mapping, not the stated efficient alternate physical relationship.
TREATAS applies selected values as filters to a different model column. That alternative targets disconnected slicer virtual relationship; this case requires efficient alternate physical relationship.
Disconnected what-if tables provide parameters without physically filtering facts. It may be appropriate for user-controlled scalar threshold, whereas the current need is efficient alternate physical relationship.






Microsoft Power BI Data Analyst (PL-300) Practice Tests