Question 190
In a Microsoft Power BI project, A marketer needs sales only for Product[Color] = 'Blue' while respecting the remaining context. Choose the most defensible solution.
Explanation
Correct Answer
This directly addresses the stated constraint. CALCULATE evaluates an expression under a modified filter context. Confirmation: The result uses blue products and retains date filters in the visual.
Incorrect Answers
A standard SUM across every daily snapshot inflates stock and misstates the month-end position. The specific problem here is that a plain SUM of Sales cannot by itself introduce the blue-only filter.
A DISTINCT list of transaction dates omits days without sales. The specific problem here is that a plain SUM of Sales cannot by itself introduce the blue-only filter.
Using only existing transaction dates can omit days and break expected date calculations. The specific problem here is that a plain SUM of Sales cannot by itself introduce the blue-only filter.