% of Total for Specific Categories

DAX DAX Calculations
1

I am wanting to calculate a % of total for specific categories and add them as a separate category to the table.

i.e.- 60% of the Christmas Category. What would be the calculation

image

2

Hello @bsteinacher,

Thank you for posting your query onto the Forum.

You can use the formula as mentioned below -

% of Total =
VAR CategoryTotal = SUMX( 
                       ALL( Products[Product Name] ) , 
                           CALCULATE( [Total Sales] ) )

RETURN
DIVIDE( [Total Sales] , CategoryTotal , 0 )

Hoping you find this useful and helps you to achieve the desired analysis.

Please Note: The naming conventions may differ so accordingly use it in your file.

Thanks & Warm Regards,
Harsh

3

HI @bsteinacher, did the response/training content provided by @user help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!