SQLTeam.com | Weblogs | Forums

Wrong grand total for calculated measure in DAX (SSAS 2016)


#1

Hi, all!

I have an issue with wrong grand total for calculating measure in DAX. The measure calculates depends of different measure and show it's positive values only:

Measure2 = IF(Measure1 > 0, Measure1, NULL)

Unfortunately, it doesn't add up correctly the grand total:

Grand Total (Measure2): 30 <-- wrong value, it should be 100

Because the grand total in DAX calculated as:
IF(50 - 10 + 20 - 60 + 30 > 0, 50 - 10 + 20 - 60 + 30, NULL)

Is there any way to calculate the grand total in right way?