Forum Discussion
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 ge...
- Current # of States =CALCULATE(DISTINCTCOUNT(Sheet1[state]),Sheet1[status]="Current")
Current # of State =
CALCULATE(COUNT(Sheet1[state]),Sheet1[status]="Current")
- Current # of States =CALCULATE(DISTINCTCOUNT(Sheet1[state]),Sheet1[status]="Current")