Forum Discussion

AndySmith's avatar
AndySmith
Icon for Helper III rankHelper III
5 years ago

SUMX Formula with conditional SUMIF

Hi - I am trying to calculate 'points' for a sales incentive where points are awarded per number of products a customer purchases.    Points = SUMX(VALUES('BrandPrint'[Customer Name]),CALCULATE(IF...
Need Help
AndySmith's avatar
AndySmith
Icon for Helper III rankHelper III
5 years ago

Thanks for looking into it. Sadly I have tried that already and it doesnt seem to change anything.

 

I have attached a link to a pbix with sample data. You can see that the Customer summary adds up but the state and salesperson tables do not total correctly. Hopefully someone can make this work!

 

https://www.dropbox.com/s/l7xi0rdgr5x2vdj/IncentiveSampleData.pbix?dl=0

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

In the first visual, the Points add up to 406 whereas they should add upto 408.  This measure gives the result as 408

Measure = SUMX(Targets,[Points])
Hope this helps.