Total is wrong

[Anonymous]

Hi,

I have the same issue than many of the community and I try to use "SUMX" but without success. Can you help me please ?

My measure is : 

For invoicing = SUM('fichier à plat'[SP_Nb of mat])-SUM(SP_Ristournes[SP_ristourne])

And the wrong total is on this screenshot : 

Sincerely 

Luca BOROME

[themistoklis · Accepted solution]

@Anonymous

Try the following formula:

invoicing = SUMX(
                  VALUES ( Table[Creation month] ),
				  CALCULATE(SUM('fichier à plat'[SP_Nb of mat]))
				)  
          - SUMX(
                  VALUES ( Table[Creation month] ),
				  CALCULATE(SUM(SP_Ristournes[SP_ristourne]))
				)