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))
awesome thanks! i realized i missed some logic at the end but your solution was exactly what i needed, thanks!
% Win Rate = CALCULATE(COUNT(table[Opportunity]),FILTER(table,[Lifecycle Status]="WON")) / CALCULATE(COUNT(table[Opportunity]),FILTER(table,([Lifecycle Status]="WON") || [Lifecycle Status]="LOST"))
Hi,
Below given is my query for calculation of WinRate% but it shows error as (DAX comparision operation donot support comparing values of type true or false with the type text consider VALUE OR FORMAT for converting)
Measure 9 = CALCULATE(SUM(Opportunity[Amount]),FILTER(Opportunity,[IsWon]="True")) / CALCULATE(SUM(Opportunity[Amount]),FILTER(Opportunity,([IsWon]="True") || [IsClosed]="False"))