Incorrect Total on table from multiple measure output

[CAkcay]

Hi,

I have issue where the below measure is not providing the correct total on my table

DMR Var ABS = IF(ABS([Actuals] - [FC Lag 4])>[FC Lag 4],[FC Lag 4],ABS([Actuals] - [FC Lag 4]))

The total I am expecting is 3239 but the visual is displaying 3335. This measures are stacked from existing measure to get this value and I would appreciate any help. 

[Anonymous]

Hi @CAkcay 

[FC Lag 4] , because the ABS() function returns positive numbers, if there are complex numbers in [FC Lag 4], it may be that the calculation result is biased, because the results calculated at this time are all qualified, if [FC Lag 4] is negative.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.