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)

Anonymous's avatar
Anonymous
Not applicable
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)