Substract not working as desired in powerBI

Victor Ruiz Perez 0
Viewed 37

I have done calculated column:

Delta = OnBoth[Values2022/03] - OnBoth[Trans Amount $ (Pos-Rev)]

But the substract sometimes gives incorrect values, the total should be 2k but it is 14k, see picture

enter image description here

powerquery dax powerbi
1 Answers

Why don't you try this for your Sum Of Delta Measure without building additional column to calculate difference.

Sum Of Delta =
SUMX ( OnBoth, [Values2022/03] - [Trans Amount $ (Pos-Rev)] )
Ozan Sen0
Related