Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX calculation

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's avatar
    Anonymous
    4 years ago
    Current # of States =
    CALCULATE(DISTINCTCOUNT(Sheet1[state]),Sheet1[status]="Current")

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    Current # of State =
    CALCULATE(COUNT(Sheet1[state]),Sheet1[status]="Current")
    • Anonymous's avatar
      Anonymous
      Not applicable
      Current # of States =
      CALCULATE(DISTINCTCOUNT(Sheet1[state]),Sheet1[status]="Current")