Forum Discussion
Anonymous
4 years agoNot applicable
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
- Anonymous4 years agoCurrent # of States =CALCULATE(DISTINCTCOUNT(Sheet1[state]),Sheet1[status]="Current")
2 Replies
- AnonymousNot applicableCurrent # of State =CALCULATE(COUNT(Sheet1[state]),Sheet1[status]="Current")
- AnonymousNot applicableCurrent # of States =CALCULATE(DISTINCTCOUNT(Sheet1[state]),Sheet1[status]="Current")