Number in data table is different to number in report table power bi

[Anonymous]

Hi All,

I can't believe this is the second time in a row that I'm reaching out today. Having real issues with my Power BI knowledge.

I have a Turnover Data Table..

I've noticed that May data is off so filtered on May. My Vol Leaver states, 3 for May 22. 

I go into the Report Page and create a table with the Turnover Table, this is connected to my date table.

I do a simple sum measure; Sum Vol Leaver = SUM(Turnover_2[Vol Leaver])

and May 22 is showing 4 leavers? 

I try SUMX, same 4 are showing. 

What is going on? How can I display the table to show 3 and not 4?

[Anonymous · Accepted solution]

Hi Amit,

Thanks for looking at this. I've just been looking at the underlying data and can see that I have merged some departments to that department so it's summing like 2 departments rather than 1. So that seems to be my issue. 

I use that level structure without the merge and it's now fine.

[HotChilli]

Maybe a rounding problem?  Is the 3 really a 3.8 but not showing the decimal places? 

[amitchandak]

@Anonymous , I doubt that is possible, unless there is some other value 

Can you share a sample pbix after removing sensitive data?