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

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

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?