Forum Discussion
Helper IIITotal of Column wrong
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.
3 Replies
Tahreem24Super User
Joseph_Hchaime Can you some sample of your data (by removing imp data)? OR share some screen shot to better dig your issue.
Joseph_Hchaimehere 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!
these are not calculated columns, i'm merely reading from an SQL database
- Tahreem24
Joseph_Hchaime Gave unauthorize error on google sheet.
Would you mind to share data in excel and attach it here?