Showing results for 
Search instead for 
Did you mean: 
New Member

Table Matrix Percentage of Totals



I have a table matrix where I just want to add a column in addition to the totals column next to it that shows the percentages of the totals. I don't want a percentage for each individual column and I don't want to change all the values to percentages, I just want to add a new column in addition to that shows the percentages of the grand total.


Thank you for your help!

Super User IV
Super User IV

I am not aware of a way to do that.


@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Solution Supplier
Solution Supplier

I gave you an answer in another post:



Cheers, Edgar Walther
ITsmart BI and Analytics consultant
Power BI User Group Netherlands

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors