% of Total Measure

[brent_excel]

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 = ?

[Vera_33 · Accepted solution]

Hi @brent_excel 

Have a try

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

[brent_excel]

 @Vera_33 Thanks so much!  This solution is perfect.