Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Jimb0
Regular Visitor

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

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..

 

Jimb0_0-1657724637778.png

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. 

 

Jimb0_1-1657724806089.png

 

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

 

 

 

1 ACCEPTED SOLUTION
Jimb0
Regular Visitor

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.

 

View solution in original post

3 REPLIES 3
Jimb0
Regular Visitor

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
Super User
Super User

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

amitchandak
Super User
Super User

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


Can you share a sample pbix after removing sensitive data?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.