Forum Discussion
Win rate calc
Good day
I need help with calculating the win rate of opportunities in different stages.
It should be Won/Won+Lost
Here is my formula thus far:
Divide(Calculate(Count(LAH Opp[Stage]), Filter(All(LAH Opp[Stage], LAh Opp[Stage] = "Won",
Calculate(Count(LAH Opp[Stage], Filter(All(LAH Opp[Stage], LAH Opp[Stage] = "Won" || LAH Opp[Stage] = "Lost")))))
Hi Christene ,
Pls try
Measure =
VAR won =
CALCULATE (
COUNT ( 'LAH Opp'[Stage] ),
FILTER (
ALL ( 'LAH Opp'[Stage] ),
'LAH Opp'[Stage] = "Won"
)
)
VAR lost =
CALCULATE (
COUNT ( 'LAH Opp'[Stage] ),
FILTER (
ALL ( 'LAH Opp'[Stage] ),
'LAH Opp'[Stage] = "Lost"
)
)
RETURN
DIVIDE (
won,
( won + lost )
)Regards,
Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Incase it does not work pls share some sample data (not in image)
2 Replies
Hi Christene ,
Pls try
Measure =
VAR won =
CALCULATE (
COUNT ( 'LAH Opp'[Stage] ),
FILTER (
ALL ( 'LAH Opp'[Stage] ),
'LAH Opp'[Stage] = "Won"
)
)
VAR lost =
CALCULATE (
COUNT ( 'LAH Opp'[Stage] ),
FILTER (
ALL ( 'LAH Opp'[Stage] ),
'LAH Opp'[Stage] = "Lost"
)
)
RETURN
DIVIDE (
won,
( won + lost )
)Regards,
Harsh NathaniDid I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Incase it does not work pls share some sample data (not in image)
- AlB
Community Champion
DIVIDE ( CALCULATE ( COUNT ( 'LAH Opp'[Stage] ), FILTER ( ALL ( 'LAH Opp'[Stage] ), 'LAh Opp'[Stage] = "Won" ) ), CALCULATE ( COUNT ( 'LAH Opp'[Stage] ), FILTER ( ALL ( 'LAH Opp'[Stage] ), 'LAH Opp'[Stage] = "Won" || 'LAH Opp'[Stage] = "Lost" ) ) )Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc
Cheers
