cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Total is wrong

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 : 
 
Capture.PNG
 
Sincerely 
 
Luca BOROME
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Re: Total is wrong

@luca_borome

 

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]))
				)  	

View solution in original post

1 REPLY 1
Highlighted
Memorable Member
Memorable Member

Re: Total is wrong

@luca_borome

 

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]))
				)  	

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors