Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Percent of total

In addition to sum, average, min, max etc. I'd like an option in values for % of total
Status: Completed
Comments
nishalit
New Member
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/
toni1
New Member
'+1
jormto
New Member
I have used ALL () function inside CALCULATE () function to achieve this one. This should be there automaticly!
mariusz_cieciur
New Member
PercentOfTotal = (SUM(Table[Column])/CALCULATE(SUM(Table[Column]),ALL(Table)))*100
dwsteven
New Member
Ton, can you share how you got it working with?
craig2
New Member
this a thousand votes please 😄
manuel_siriann1
New Member
If i have multiple column groups...i can't use the ALL function.
manuel_siriann1
New Member
after one year, how proceed this implementation?? how i can add percentage of rows in matrix with a measure instead?
alberto_martin
New Member
Please we need it!!!
nivek142
Regular Visitor
When this will be released?