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 looks like this, with the Product column in the row fields.

 

 

I am unsure of which measure to use to get the %TotalQty.

 

TotalQty = SUMX(FILTER ('Data', 'Data'[Time] = "Current"), 'Data'[Qty])

%TotalQty = ?

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    Have a try

    %TotalQty = [TotalQty] / CALCULATE ([TotalQty],ALL('Data'[Product]))

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

     

    Have a try

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

       Anonymous Thanks so much!  This solution is perfect.