Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
@Joseph_Hchaime Can you some sample of your data (by removing imp data)? OR share some screen shot to better dig your issue.
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!
these are not calculated columns, i'm merely reading from an SQL database
@Joseph_Hchaime Gave unauthorize error on google sheet.
Would you mind to share data in excel and attach it here?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
111 | |
59 | |
57 |