I am using a single table which I am fetching from SQL via direct query. There are 4 columns and a date. I just want to add a total of 4 columns. See below image. When I click on "Don't summarize", it is showing the values correctly. See the next image.
When I click on the sum, it is giving the wrong totals.
Hi Kolumam,
This might be related to duplicated value in your table, if you data sample like below
You could see that I set don't summarize, it will show distinct value of "a" in table, if you have a unique value as key like "sid", then when you insert this in table visual, it will show all data instead of distinct value (when you click don't summarize). So you total is correct, you could check whether you have duplicated value of each date.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Kolumam,
This might be related to duplicated value in your table, if you data sample like below
You could see that I set don't summarize, it will show distinct value of "a" in table, if you have a unique value as key like "sid", then when you insert this in table visual, it will show all data instead of distinct value (when you click don't summarize). So you total is correct, you could check whether you have duplicated value of each date.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
