% of Total for Specific Categories

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


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] ) )

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,

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!