The total generated by the table display does not work

[Syndicate_Admin]

Good afternoon community, I'll tell you the problem I have.
I'm creating a table visualization, I have a column called "ADJUSTMENT OF m2" which is the result of the subtraction of two columns let's call them "COLUMN A" - "COLUMN B", with the condition that "COLUMN A" is greater than "COLUMN B" to avoid negative results, if so I place a 0.
The detail is that the total generated by the visualization is wrong, it seems that it adds all the values, even those that have negative results, it does not take into account the value 0
It's the example with negative values

It is the example by conditioning the negative values and placing them at 0, the result should be 710.88, but somehow it takes into account the negative values and not the zeros

I would greatly appreciate your support, as I can't find a way to make it work well.

[MattAllington]

Read my article here. https://exceleratorbi.com.au/use-sum-vs-sumx/

towards the bottom is a section "totals don't add up". 

[Greg_Deckler]

@Syndicate_Admin First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[Syndicate_Admin · Accepted solution]

Thank you so much for the support, this video helped me a lot https://youtu.be/n4TYhF2ARe8