Forum Discussion
Anonymous
5 years agoNot applicable
% 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 = ?
- Anonymous5 years ago
Hi Anonymous
Have a try
%TotalQty = [TotalQty] / CALCULATE ([TotalQty],ALL('Data'[Product]))
2 Replies
- AnonymousNot applicable
Hi Anonymous
Have a try
%TotalQty = [TotalQty] / CALCULATE ([TotalQty],ALL('Data'[Product]))- AnonymousNot applicable
Anonymous Thanks so much! This solution is perfect.