Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 the %win rate as (COUNT of opps that have status = "WON" / COUNT of all opps)
This would be a great KPI or card value to show in a dashboard.
As well, i have slicers in the dashboard and i'm hoping this value changes as the slicers are applied (by territory, business unit, etc)
I am not even sure where to start, anything to point me in the right direction would be appreciated.
Thanks in advance.
Solved! Go to Solution.
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))
I want to make a slight aleration to the formula that you've provided in the past. Instead of divided the data by the total, I want to divide it by win +loss.
Bottom line I want to see win / (win+loss)
Thought, something is not working -- I am a novice
Hi,
I have several statuses and need help with the dax formula. Also a slight alteration.
Basically here are the statuses:
Win, Loss & Kept-In-House.
To get win the Win Ratio, I need help for dax that will convert this formula
Win Ratio = Win/ Loss + Kept-In-House.
Any help would be greatly appreciated.
Thank you.
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"))
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |