Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Budfudder
Helper IV
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
ChrisMendoza
Resident Rockstar
Resident Rockstar

@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)





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar

@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)





Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Thank you, perfect!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors