Question 140
A model/report has an issue while addressing this requirement: The company requires simultaneous independent Order Date and Ship Date slicers on a single visual. Which mistake would account for the observed failure?
Explanation
Correct Answer
This defect explains why the required behavior failed. Separate role-playing dimensions support simultaneous independent date-role filtering. The corrective action is: Create separate role-playing calendar dimension tables for order and ship date with appropriate active relationships.
Incorrect Answers
Joining facts to mutable display names can create unmatched historic rows. The stated evidence instead indicates: Reusing one calendar field for both independent slicers cannot express two different role filters reliably.
AVERAGE(Sales[UnitPrice]) weights every row equally even when sold quantities differ. The stated evidence instead indicates: Reusing one calendar field for both independent slicers cannot express two different role filters reliably.
Persisting every temporary arithmetic result can needlessly enlarge the semantic model. The stated evidence instead indicates: Reusing one calendar field for both independent slicers cannot express two different role filters reliably.