Re: Total of Column wrong

Joseph_Hchaime · ‎09-23-2022

I'm direct querying a column from a table on SQL. The individual records are correct. The total at the bottom is wrong. (I checked by exporting to excel and summing up). I tried to convert that column into a Measure by using SUM of that column, same result. the total at the bottom is wrong. How can I fix that?
when I Select all the records on Excel, the total is correct so i'm sure my data and relationships are correct.

Tahreem24 · ‎09-23-2022

@Joseph_Hchaime Can you some sample of your data (by removing imp data)? OR share some screen shot to better dig your issue.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

Joseph_Hchaime · ‎09-23-2022

here is a link to the dataset in excel. If you select the first column the total at the bottom right of the screen is correct. However it's showing differently in PowerBI. Same for the last column. What's weird is the two columns in the middle are correct!

https://docs.google.com/spreadsheets/d/1-6afP18X28n64jxzZ8qambKxj0dhMFEX/edit?usp=sharing&ouid=11055...

these are not calculated columns, i'm merely reading from an SQL database