Percent of total

[haydnr]

In addition to sum, average, min, max etc. I'd like an option in values for % of total

[parmezana1]

I was also getting really frustrated with this, but the solution is a very simple principle. by creating a column named "percent" which is the following calculation: Percent = 1/COUNTROWS(Table1) and format it as %, you automatically can drag it as a value to any kind of chart/graph and will display accurate % value.

[dpestrikov]

The suggested "ALL" fix will not work if there are slicers that limit your table display selected by the User. The % of Total needs to be out of a dynamic table that keeps changing based on user inputs and the percentages continue to readjust as the total changes. ALL ignores all filters and ALLEXCEPTS are limited.

[angiee1]

% of total is definitely needed

[judit_bogos]

'+1 please! Plus may I suggest all the functionalities of the ThinkCell ppt add-on? 🙂

[Dawngrrl]

Please please please

[Bartosz]

ThinkCell features are nice to have

[daz_hall]

There is a blog here http://www.cognim.co.uk/power-bi-quick-tip-percent-of-total/ that shows one way to do it.

[Surendra_Mettap]

%OfTotal=(Table[TotalAmount])/CALCULATE(Table[TotalAmount],ALLSELECTED () )*100 Note: TotalAmount is the measure in my dataset.

[hagrawal]

This is a must have!

[jenny_fogarty]

This is a no brainer!!!