Power Pivot DAX dynamic Percent of Column

Solution 1:

You should use ALLSELECTED around the field you have on the rows in the pivot table, like this:

% Total = [TotalQuantity] / CALCULATE( [TotalQuantity] ,ALLSELECTED( 'Table'[FieldUsedOnRows] ) )

You can also just put the Table name inside ALLSELECTED, but that would mean the denominator will be the sum of all the cells in the pivot table (across all rows and columns for that measure), and so would be the equivalent of the '% of Grand Total'. This is fine if you have no column headers - you can put multiple fields in the rows and still get '% of column total'. Otherwise, it would be more accurate that you want to create '% of measure by specific field'.

Last year I started and (quickly) stopped a blog about this kind of stuff. But one of the very few posts I wrote was about this particular subject.

https://www.flexyourdata.com/blog/excel-calculate-the-difference-between-percentage-of-column-total-columns/