Outlier piece of data doesn't add up to the total

[matheus_mk0]

hi everyone,

Im trying to build a dashboard that summarizes all the outcome that a person had in a semester. So i have to summarize all the data from the semester, but for some reason some outlier data keeps apearing on the table and not adding up to the hole number, as you can see below:

It happens multiple times with different persons on my dashboard. Funny enough, 2.811.169,78 would be the desired result (as I checked on excel).

Im pretty sure that's something wrong with "COLABORADOR" column but I can't figure it out. 

Obs.: the data from "COLABORADOR" and "OUTCOME" are from the same spreadsheet

Any ideas?

Thanks in advanced

[matheus_mk0 · Accepted solution]

So after a few hours of trying and failing i finally found a solution. Sharing here in case anyone have the same issue in the future, although i doubt it because it was a very specific situation.

To make it short: I was working with a database of clients, and some of them aren't clients anymore, so they didn't appear on the fact table, but appreared in the table with the history of transactions they did while were clients.

I connected the 2 tables using the client's ID number, and it didn't work.

All I did to solve this was connecting by the name of the employee responsible of which client, worked like a charm.

[adudani]

hi @matheus_mk0 ,

I think it might be a missing value on the dimension which appears in the fact table.

Maybe this reference might help : Understanding and fixing blank values in Power BI - YouTube