DAX calculation

[Anonymous]

Hi  All -- 

I am looking to calculate the # of current State by using column (state) and Column (Status) where Status says current. And need to filter/remove duplicates under column (state) to get the right value.

Thank you

[Anonymous]

Current # of State =

CALCULATE(COUNT(Sheet1[state]),Sheet1[status]="Current")

[Anonymous · Accepted solution]

Current # of States =

CALCULATE(DISTINCTCOUNT(Sheet1[state]),Sheet1[status]="Current")