cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper IV

## Calculating Percentage

I have a table with 15K rows, each of which is a potential order. Each row has a status of Open, Lost or Won. I've created three extra columns, one for each of those status, and populated them with:

Status Won = IF (Status = "Won", 1, 0)

and the same for Status Lost and Status Open. So I end up with values in the three columns in the thousands. Great.

I want to calculate the percentage of orders that were won - so, basically, Status Won / (Status Won + Status Lost)

I tried doing it with a calculated column, but of course it calculated it for each row, which was useless. I want the percentage of the total number of Won vs Won + Lost.

1 ACCEPTED SOLUTION
Resident Rockstar

Would this work for you?:

```measure =

VAR countLost = CALCULATE(COUNTROWS(Table2),Table2[Status]="Lost")
VAR countWon = CALCULATE(COUNTROWS(Table2),Table2[Status]="Won")

VAR denominator = countWon + countLost

RETURN DIVIDE(countWon, denominator, 0)```

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

2 REPLIES 2
Resident Rockstar

Would this work for you?:

```measure =

VAR countLost = CALCULATE(COUNTROWS(Table2),Table2[Status]="Lost")
VAR countWon = CALCULATE(COUNTROWS(Table2),Table2[Status]="Won")

VAR denominator = countWon + countLost

RETURN DIVIDE(countWon, denominator, 0)```

Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!

Helper IV

Thank you, perfect!