cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brent_excel
Frequent Visitor

% 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.

brent_excel_1-1619072356822.png

 

My pivot table looks like this, with the Product column in the row fields.

 

brent_excel_3-1619072625648.png

 

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

 

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

%TotalQty = ?

 

1 ACCEPTED SOLUTION
Vera_33
Solution Sage
Solution Sage

Hi @brent_excel 

 

Have a try

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

View solution in original post

2 REPLIES 2
Vera_33
Solution Sage
Solution Sage

Hi @brent_excel 

 

Have a try

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

View solution in original post

 @Vera_33 Thanks so much!  This solution is perfect.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors