topic Re: Win rate calc in DAX Commands and Tips

Win rate calc

Christene — Mon, 25 May 2020 12:48:32 GMT

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")))))

Re: Win rate calc

Anonymous — Mon, 25 May 2020 12:58:03 GMT

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 Nathani

Did 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)

Re: Win rate calc

AlB — Mon, 25 May 2020 13:19:37 GMT

Christene

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