Subtracting two measures with If condition in dax not showing up a total

[Anonymous]

In DAX, I am trying to subtract one measure from another , lets say A-B and I wrote a condition (If A>B, A-B, 0). I am not able to get the total of this measure. 

[Anonymous]

I am trying to subtract two measures, A-B with a condition that if it is negative value then it should be 0. I am not able to get the total value

[v-lili6-msft]

hi, @Anonymous

It is a measure totals problem. Very common. 

here is a post for you to reference:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

IF not your case, Please share some data sample and the formula and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading

Best Regards,

Lin

[AkhilAshok]

If you want the total to work correclty then you should do a SUMX (assuming you looking for sum):

Final Measure =
SUMX (
    VALUES ( Table[Dimension Used in your table] ),
    VAR a = [A]
    VAR b = [B]
    RETURN
        IF ( a > b, a - b, 0 )
)