You are writing a measure that should sum Sales[Sales Amount] but only for rows where Product[Color] equals Blue, regardless of any color filter the visual applies. Which DAX function evaluates an expression in a modified filter context?
- AWrap the SUM in CALCULATE and pass Product[Color] = "Blue" as the filter argument. Correct
- BWrap the SUM in SUMX and pass Product[Color] = "Blue" as the filter argument.
- CWrap the SUM in SUMMARIZE and pass Product[Color] = "Blue" as the filter argument.
- DWrap the SUM in RELATED and pass Product[Color] = "Blue" as the filter argument.
Why A is correct: Correct. CALCULATE evaluates an expression in a modified filter context.
Why B is wrong: SUMX iterates a table and evaluates an expression per row; it does not accept a Boolean filter argument that modifies filter context.
Why C is wrong: SUMMARIZE groups a table by columns and returns a table; it is not the filter-context modifier for a scalar expression.
Why D is wrong: RELATED follows a relationship from a row context to fetch a single value; it does not modify filter context for an aggregation.