I just started using Power Pivot and Dax. Today I learned the benefits of creating my own measures (counta, etc) vs creating them directly in the pivot table. So I thought I could do the same thing with percent to column total. I know I can easily do this with “Show Values As % of Column Total”.
I’ve visited a few different Microsoft and other websites and still don’t quite get it. I used the below and a variation with ALLEXCEPT but neither of these behave dynamically exactly like the “Show Values As > % of Column Total.” Dynamically = add any column to Filters or Rows section.
How do you do what I want or is it not possible?
I thought I had it with the below but when I added another filter to the pivot table it did not behave dynamically. AI also tried ALLEXCEPT and that works but I would have to write in over a dozen columns.
source: https://community.powerbi.com/t5/Developer/Percent-of-Total/m-p/15258
% Total =
[TotalQuantity]
/ CALCULATE(
[TotalQuantity]
,ALL( ‘Table’ )
)
