Forum Discussion
sum is incorrect
hello
I am very new to power bi, please excuse me if I am doing something wrong.
basically i have my table on excel and i uploaded it on power bi but the sum on excel is not the same as when i create a table on Power bi.
please see screenshots. what am i doing wrong? thanks for the help.
12 Replies
Please check the count also, Right-click on the measure in the visual pane and change Agg to count. Are rows matching?
Can you share sample data. If possible please share a sample pbix file after removing sensitive information.Thanks.
My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970What do you mean Agg?
It is set at Sum.
The actual sum is correct but it is not correct for the actual categories.
its like it is not picking up all the sales for each category, for example the sales should be at 10000 euros, it is only showing 3000 euros.
As a first step. Check the count of rows in powerbi to ensure all rows are loaded.
If possible please share a sample pbix file after removing sensitive information.Thanks.
Try to Change datatypes to Fixed Decimal Number and set two decimal places.
Regards,
Lin
