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?