How do I use CALCULATE to filter a measure?

Asked Viewed 33 times Solved
0

I want total sales for the Government segment only, as a measure.

DAX and Transform AI Insights 365 Team

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

AI Insights 365 Team ·

Your answer

Know the answer? Sign in to help. It's free.