Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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"))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |