Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

% of Total Measure

Hello,   I am tyring to figure out how to get the % of Total measure into a PowerPivot table.   My data is structed this way, with columns for Product, Time and Qty.   My pivot table look...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    Have a try

    %TotalQty = [TotalQty] / CALCULATE ([TotalQty],ALL('Data'[Product]))
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

 

Have a try

%TotalQty = [TotalQty] / CALCULATE ([TotalQty],ALL('Data'[Product]))
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

     Anonymous Thanks so much!  This solution is perfect.