DAX formula - Wrong subtotal/total in a table

[Jomachado1]

Hello, 

I ve a table with the comsuptions by prodution order and then the drilldown by material.

I want to calculate the amount in euros of the difference between the real and teorical consumptions.

The delta (in units and euros are correct). But the total of the delta in euros at order level not (should be the sum of the material differences).

The data have the following structure:

One table with the real consumptions by production order and material;

One table with the teorical consumptions by production order and material;

Another table with price of each material in euros;

The measure that I want to fix is:

 Any suggestion?

[dharmendars007 · Accepted solution]

Hello @Jomachado1 , 

You can use SUMX to bring the row context in the calculation, please try the below measure..

Delta in euros =
SUMX('Material Table',
CALCULATE(SUM('Price Table'[Unit Price]) *
(SUM('Real Consumption Table'[Consumption]) - SUM('Theoretical Consumption Table'[Consumption]))))

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[Jomachado1]

Thanks Dharmendar  for the quick response.

The soluction propose works perfectely!