Haydn Richardson on 06 Dec 2014 03:56:36
In addition to sum, average, min, max etc. I'd like an option in values for % of total
Administrator on 01 Jun 2016 05:13:31
We shipped % of grand total as a part of quick calcs in the May release of Power BI desktop. Next up, % of column and % of row total. Give it a try and let us know what you think. For info on how to use it, check out the blog post covering our May feature releases: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-update-feature-summary/
- Comments (78)
RE: Percent of total
Please we need it!!!
RE: Percent of total
after one year, how proceed this implementation?? how i can add percentage of rows in matrix with a measure instead?
RE: Percent of total
If i have multiple column groups...i can't use the ALL function.
RE: Percent of total
this a thousand votes please :D
RE: Percent of total
PercentOfTotal = (SUM(Table[Column])/CALCULATE(SUM(Table[Column]),ALL(Table)))*100
RE: Percent of total
Ton, can you share how you got it working with?
RE: Percent of total
I have used ALL () function inside CALCULATE () function to achieve this one. This should be there automaticly!
RE: Percent of total
'+1