SUM function gives negative result on positive values

[aac]

Hello

I am relatively new here.

I have started playing with Power BI around 2 months ago.
Even though Microsoft is not the best at providing the best to its consumers, some people manage to find solutions for things that were left out by Microsoft.

I have recently run into an issue, where I am trying to SUM up positive records from a column, but I have no idea how comes that I am getting a negative result.
This would be the table:

I am trying to SUM the 'Target weighted' column, and I am expecting a positive sum, but when putting it as maximum value for a visualization, I get this:

You can see the -8.18M from maximum.

Can someone explain me what did I do wrong or why is it negative?

Thank you for your time!

[Anonymous]

HI @aac,

I can't reproduce your issue, can you please share sample pbix file to test?
BTW, I'm not so clear which column you used on value field, can you explain please more clearly?

Regards,

Xiaoxin Sheng