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 ...
Hello
I realised that alot of the rows are missing.
Please see screenshot how some of the ID codes are missing.
Sorry for not sharing the file, its just that the data (numbers) it self is sensitive.
here is a clearer example and comparison between the excel data and PBI data.
As you can see the data in yellow is missing and the ones in green are appearing on PBI.
Please check you have the filter applied anywhere eg. in edit queries or page/report level filter.
if possibel, could you please remove sensitive data columns and share it for us have a test?
Regards,
Lin
I have no filters or anything. I literarly, just selected table as visualisation and selected sales and service name.
See screenshot:
