Forum Discussion
Solved
Need help calculating % Win Rate
Hi All, Fairly new to Power BI and what 'm trying to do is calculate the %Win Rate for a table that is showing all our sales opportunities. Each sales opp, has a status and i want to calculate ...
Measure = CALCULATE(COUNT(Table[Column]),FILTER(Table,[Status]="WON")) / CALCULATE(COUNT(Table[Column]),ALL(Table))
Measure = CALCULATE(COUNT(Table[Column]),FILTER(Table,[Status]="WON")) / CALCULATE(COUNT(Table[Column]),ALL(Table))