Forum Discussion

Poornima2023's avatar
Poornima2023
Helper I
2 years ago
Solved

Formula to create win%

I need help in making measure where in I want to calculate Win%=Win/(Loss+Win)(The data contains pipeline where status is win, lost and active)   Please help
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Poornima2023 ,

    Please try to create a measure with below dax formula:

    Win% =
VAR tmp =
    FILTER ( ALL ( 'Table' ), 'Table'[Status] = "Won" )
VAR tmp1 =
    FILTER ( ALL ( 'Table' ), 'Table'[Status] IN { "Lost", "Won" } )
VAR _a =
    SUMX ( tmp, [Value] )
VAR _b =
    SUMX ( tmp1, [Value] )
RETURN
    FORMAT ( DIVIDE ( _a, _b ), "Percent" )

    For more details, please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vinodDrinkPak's avatar
vinodDrinkPak
Helper II
2 years ago

Poornima2023 

 

Win Percentage =
DIVIDE(
CALCULATE(
COUNTROWS('Pipeline'),
'Pipeline'[Status] = "Win"
),
CALCULATE(
COUNTROWS('Pipeline'),
'Pipeline'[Status] = "Win" || 'Pipeline'[Status] = "Lost"
),
0
)