Question 280
A solution was implemented for this need: A measure must keep an existing multi-color slicer and intersect it with a promotion restriction instead of overriding it. The selected approach was: Use CALCULATE with `KEEPFILTERS(Product[Color] = "Blue")` for the intended intersection. Which result most directly proves it worked?
Explanation
Correct Answer
This checks the actual result rather than a saved setting. KEEPFILTERS causes CALCULATE filter arguments to intersect matching existing filters. A failed implementation may show: A normal Boolean CALCULATE filter may replace the same-column slicer rather than intersect.
Incorrect Answers
Changing a country display label does not break relationships to historical sales. However, this does not establish the required outcome: a slicer selecting only Red produces no Blue Revenue and selecting Blue plus Red returns Blue Revenue.
A year filter produces aligned results across facts using one reporting calendar. However, this does not establish the required outcome: a slicer selecting only Red produces no Blue Revenue and selecting Blue plus Red returns Blue Revenue.
A contiguous date row exists for each day from the first through last transaction date. However, this does not establish the required outcome: a slicer selecting only Red produces no Blue Revenue and selecting Blue plus Red returns Blue Revenue.