Forum Discussion

Christene's avatar
Christene
New Member
6 years ago
Solved

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]), Filte...
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
6 years ago

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