Forum Discussion
Anonymous
3 years agoNot applicable
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.
- CALCULATE(COUNTROWS('table'),'table'[state]="won")
1 Reply
- darry3niFrequent VisitorCALCULATE(COUNTROWS('table'),'table'[state]="won")