Win rate calc

[Christene]

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

[AlB]

@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 

[harshnathani · Accepted solution]

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)