cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarkusHaas
Regular Visitor

Percentage out of two collums

 Hi, I have two columns, "Total" and "Done". I want to calculate the Percentage, if "Total" is 4 and "Done" is 2 it gets 50%.

In the end I would like to have this in a stacked column chart.

Can anyone help?

1 ACCEPTED SOLUTION

Thanks, but I solved it with the DIVIDE() Function because it can handle Errors, such as "Divide by 0".

 

Percentage = DIVIDE(table[Done],table[Total],0)

View solution in original post

3 REPLIES 3
MarkusHaas
Regular Visitor

Hi, I have two columns "Total" and "Done". I would like to calculate the percentage, that if "Total" is 4 and "Done" is 2 it gets 50%.

Also I would like to have this into a stacked column chart. Thanks!

Anonymous
Not applicable

Hello @MarkusHaas

 

Try this

 

% Percentage=SUM(Done) / SUM(Total)

 

Hope this was helpful

Thanks, but I solved it with the DIVIDE() Function because it can handle Errors, such as "Divide by 0".

 

Percentage = DIVIDE(table[Done],table[Total],0)

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors