How do I use CALCULATE to filter a measure?
0
I want total sales for the Government segment only, as a measure.
1 answer
0
Accepted answer
Government sales = CALCULATE(SUM([Sales]), [Segment] = "Government"). CALCULATE evaluates the expression with the extra filter applied.
More detail: DAX measures and calculated columns
Your answer
Know the answer? Sign in to help. It's free.