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?
Go to 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
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!
% Percentage=SUM(Done) / SUM(Total)
Hope this was helpful
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!