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

[AndreasHermle]

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

[AndreasHermle · Accepted solution]

Dear Experts: I found my own solution: 

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