Calculate Sum of two measures

[saud968]

Hi Guys, 

I have seen multiple articles however, the sum of two measures is not working.  In the below screenshot "28" is Week Number and below are the count of the measures. So i am trying to get the sum of measure CMS DSAT + CW D-SAT in Combined DSAT however, as you can is i am getting value as 0 and not 5 for Week 28 or 7 for Week 29

These are the 2 two measures 

CMS D-SAT = CALCULATE(COUNT('MDA Sheet'[CSAT]), FILTER('MDA Sheet', 'MDA Sheet'[CSAT] = 1 || 'MDA Sheet'[CSAT] = 2 ))

CW D-SAT = CALCULATE(COUNT(CSAT[Score]), FILTER(CSAT, CSAT[Score] = 1 || CSAT[Score] = 2 ))

i have tried this not working - 

Combined DSAT = CALCULATE([CMS CSAT Detractor] + [CW CSAT Detractor])  @AllisonKennedy @amitchandak @ChrisMendoza @Jihwan_Kim @Greg_Deckler 

[saud968 · Accepted solution]

i was able to figure out guys

Combined DSAT = CALCULATE(COUNT('MDA Sheet'[CSAT]), FILTER('MDA Sheet', 'MDA Sheet'[CSAT] = 1 || 'MDA Sheet'[CSAT] = 2 )) + CALCULATE(COUNT(CSAT[Score]), FILTER(CSAT, CSAT[Score] = 1 || CSAT[Score] = 2))

This worked putting this here if someone else like me run into similar problem

[TomMartens · Accepted solution]

 Hey @saud968 ,

great that you figured out how to tackle you challenge!

Nevertheless I'm interested why you did not simply use:

Combined DSAT = [CMS D-SAT] + [CW D-SAT]

Regards, 

Tom

[saud968]

Yeah weird I should have tried that but not sure why I did not try it. Sometimes I overthink and miss on simple things I guess this was one of that thing

[saud968 · Accepted solution]

i was able to figure out guys

Combined DSAT = CALCULATE(COUNT('MDA Sheet'[CSAT]), FILTER('MDA Sheet', 'MDA Sheet'[CSAT] = 1 || 'MDA Sheet'[CSAT] = 2 )) + CALCULATE(COUNT(CSAT[Score]), FILTER(CSAT, CSAT[Score] = 1 || CSAT[Score] = 2))

This worked putting this here if someone else like me run into similar problem