Need to understand how DAX formula is being calculated for combination of SUMX, ALLEXCEPT AND SUM

[abhisheksan007]

Dear All,

I am struggling to understand the backend functioning of some DAX Formulae.

Below is my test data :

I am trying to understand how below meaures are being calculated in some scenarios :

1. Scenario 1

Category Sales = SUMX(ALLEXCEPT(Sheet1,Sheet1[Category]),SUM(Sheet1[Sales]))

Output :

2. Scenario 2

Category Sales = SUMX(ALLEXCEPT(Sheet1,Sheet1[Sub Cat]),SUM(Sheet1[Sales]))

Output :

3. Scenario 3

Category Sales = SUMX(ALL(Sheet1[Category]),SUM(Sheet1[Sales]))

Output:

4. Scenario 4

Category Sales = SUMX(ALL(Sheet1[Sub Cat]),SUM(Sheet1[Sales]))

Output:

5. Scenario 5: Added calculated table

Table = ALLEXCEPT(Sheet1,Sheet1[Sub Cat])

Category Sales = SUMX('Table',SUM('Table'[Sales]))

Output :

6. Scenario 6: Added calcualted table

Table = ALLEXCEPT(Sheet1,Sheet1[Category])

Category Sales = SUMX('Table',SUM('Table'[Sales]))

Output

It would be great help if someone can help me understand how the calcualtions are being computed on the backend in all these scenarios in absence of CALCULATE function and how the output is being generated. Thanks in advance!

Regards,

AD

[ThxAlot]

Here's the reference to ALLEXCPET

ALLEXCEPT - DAX Guide

Use such a measure to reveal some details of calculation

DEBUG = TOCSV( ALLEXCEPT(Sheet1,Sheet1[Category]), 100, ", ", TRUE() )