TABLE VIEW AND REPORT SHOWING DIFFERENT FIGURES

The "table view" is your raw data as it has been loaded  into the Vertipaq engine. No filters are applied, and the data model has no impact.

In the DAX measure you will be impacted both by the applied filters and by the data model.  Check the filter icon on the visual where you use the measure. It will tell you which filters are currently applied.

Hi, alwaysnelsun ;

Such as @lbendlin said, You can check if you're using a filter in your power query.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you @lbendlin and v-yalanwu-msft .

I have tried to fix this error using the suggested solution but the issue is still persisting.

I think I should provide more details. I imported sales data for 2months- say August and September 2022 using the folder options of Getdata. The two months sales data were combined in the power query. I have a filter by month slicer on my visuals. The measure that calculates total monthly sales returns the correct figure for August, but returns incorrect sales figure for September. I am just wondering where I have erroneously placed a filter that affects only September sales figure.

Hi, alwaysnelsun ;

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.