Incorrect Sum

[Unicorn_Tech]

Anyone know how to explain this?  Why isn't my second column (Licensed Ha) summing the same way as the third column?

[Unicorn_Tech]

Hi.  I've checked throughout the forum and I found this in another explanation:

Measure3 = SUMX(VALUES('Table1'[Tax Group]),IF([Measure1]>[Measure2],[Measure1],0))

So what I did is I created a measure, based on my column Licensed Ha 2, with the sumx formula.  That is adding correctly.

The strange thing is that it is now causing the third column to be inaccurate.  Which is really strange.  Why does this happen?

[v-lili6-msft]

hi, @Unicorn_Tech

It seems a measure total problem, here is a post for you refer to

https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

If it is not your case, please share some data sample and formula of measure for us. Do mask sensitive data before uploading. 

Best Regards,

Lin