Calculating Percentage

[Budfudder]

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.

[ChrisMendoza · Accepted solution]

@Budfudder,

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)

[Budfudder]

Thank you, perfect!