Forum Discussion

Budfudder's avatar
Budfudder
Helper IV
8 years ago
Solved

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.

Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    8 years ago

    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)

2 Replies

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    8 years ago

    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)