Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Help with Measure totals in Matrix

Hello PBI community, Thanks in advance for your help.   I have the attached problem with these Calculation im trying to perform.   Issue is my totals are not maching up as per the last Measure on...
Need Help
TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

Hi Anonymous ,

Please try to create a separate measure using the query "IF ([Proj vs Sales Target New] >0,1,0)" to check which step has caused this problem, after analyzing the image you shared, the [Proj vs Sales Target New] displays () outside the data, this may cause the problem.

Best Regards,

Teige

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi TeigeGao ,

Thanks for the suggestion.

I added 

$ Incentive Check = IF([Proj vs Sales Target NEW]>0,1,0)
 
then I changed
$ Incentive = CALCULATE([Proj vs Sales Target NEW],FILTER('Non-Detection Daily - Quarter3',[$ Incentive Check]=1))
 
Unfortunately, I see the meassure doing something wrong in the Sum. Im expecting to see 13MM in the total