Forum Discussion
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
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.
There is single table in which status is marked as lost, win and active.
The win% formula needs to be win%=won/(lost+won)
Example of table is as below:
Projetc Name | Value | Status |
A | 5 | Won |
B | 10 | Won |
| C | 100 | Lost |
| D | 40 | Active |