Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Help needed with count measure

Hello everyone. I want to create a measure where i have to show the total count of  "wins" from a column called "table[state]". The column called "state" has two values, "won" and "lost". I have to show count of wins where state = won. How can we achieve this using measures? Any help would be appreciated. 

1 Reply

  • darry3ni's avatar
    darry3ni
    Frequent Visitor
    CALCULATE(COUNTROWS('table'),'table'[state]="won")