Forum Discussion

nleuck_101's avatar
nleuck_101
Continued Contributor
2 months ago
Solved

Negative values not be summed correctly

Hello All,   I have some data that has negative values but it doesn't seem to be adding up correctly. In the Report view, it's not showing one of the values as negative but in the Table view it has...
Need Help
  • nleuck_101's avatar
    nleuck_101
    2 months ago

    We ended finding the issue. There was a relationship with another table with incomplete data. This was filtering out some of my data. Once it was fixed the math started to add up correctly.

Ahmed-Elfeel's avatar
Ahmed-Elfeel
Super User
2 months ago

Hi nleuck_101,

I hope you are doing well today ☺️❤️

 

So at first you should know that the format Whole Number does not control the math its just only controls how the value is displayed that means:

  • If your total should be 7 but Power BI shows 9 so you need to check these first:

    • Make sure the field is truly numeric in Power Query or Data view tab

    • Verify it is not some how converted with something like ABS() or any custom column

    • In the visual use an explicit measure like the one provided by Parchitect
    • Put ItemQuantity in a Table visual and set it to Do not summarize to confirm the raw values 

So the most likely issue is that the report visual is not using the raw negative value correctly or the value is being changed before aggregation

 

if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
nleuck_101's avatar
nleuck_101
Continued Contributor
2 months ago

We ended finding the issue. There was a relationship with another table with incomplete data. This was filtering out some of my data. Once it was fixed the math started to add up correctly.