Use a different denominator for the dax computaton of the % of Grand Total

AndreasHermle — Mon, 13 Nov 2023 11:42:54 GMT

Dear Experts:

I got the following Data Model:

Tables:

Product Category - Product SubCategory (1:n relationship)

Product SubCategory - Product (1:n relationship)

Product - Sales (1:n relationship)

I created a calculated column in the Product Category Table that shows me the percentage of Grand Total Sales for Each Category.

% of Grand Total Sales = Divide(SUMX(RELATEDTABLE('Sales'), 'Sales'[SalesAmount]), CALCULATE(SUMX(RELATEDTABLE('Sales'), 'Sales'[SalesAmount]),ALL('Sales')))

The dax formula works just fine. I am just curious how the Denominator could be formulated differently, i.e. using some other DAX-function instead of Calculate. Is this possible?

Help is very much appreciated. Thank you very much in advance.

Kind Regards, Andreas

Re: Use a different denominator for the dax computaton of the % of Grand Total

AndreasHermle — Mon, 13 Nov 2023 17:50:16 GMT

Dear Experts: I found my own solution:

% of Grand Total Sales-NEW = Divide(SUMX(RELATEDTABLE('Sales'), 'Sales'[SalesAmount]), SUMX(ALL('Sales'), 'Sales'[SalesAmount]))

topic Re: Use a different denominator for the dax computaton of the % of Grand Total in DAX Commands and Tips

Use a different denominator for the dax computaton of the % of Grand Total

Re: Use a different denominator for the dax computaton of the % of Grand Total