cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ekimfusion92
New Member

Issues with Values once data is loaded

Hi,

 

I am having issues getting my table in PowerBI to properly showcase sum of values in one of my columns. I have compared the values in Excel (pivot table) and python which these tools are matching but once I load the source file into PowerBI one of the column's values is incorrect.

 

A little background into my source file, it is a little over 5 million rows, 16 columns, and is around 502 mb.

 

The column I am looking at is 'Media Cost'

 

excel.PNG

 

This is my expected values from the source file. I used Excel's pivot table to see what I should be expecting. The column I am looking at 'Media Cost'

 

python.png

 

I also looked at this data in python pandas to see if my values match and see if there is anything off in terms of rows. I am getting the expected values from my source file as confirmed by excel.

 

powerbi.PNG

 

Here is what my table looks like once I load my source file into Powerbi, you can see 'Media Cost' being significantly different while 'Impressions' matches exactly. 'Media Cost' is not a calculated field.

 

 

Can someone help me troubleshoot what went wrong? My initial thought was a load issue, I tested out encoding 'utf_8', checking to see if any rows were missing (there are not), 'Media Cost' data types (none of that made a difference). I also have no filters on. Its weird that 'impressions' is correct but 'Media Cost' is not.

 

Thanks!

1 REPLY 1
MFelix
Super User
Super User

Hi @ekimfusion92 ,

 

Have you checked the type of summarization on the visualization for the Media Cost? 

 

Are you using the same columns to make your summary? Looking at the data you present on the Excel pivot table you only have a 6 rows and it seems to me they are filtered out however you have much more lines in Power BI and they are not filtered out.

 

If this is based on an import mode you can also try to do the grouping in Power Query and check if the result is the same.

 

Don't know if is also the case but if this model have several tables with relationships, you may also need to check the relationship because they can affect the result if you don't use the correct columns on your visualizations.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.