Extraction from Table visual to Excel Giving errors in total showing in excel when manualy counted

Hi Saurabhuu ,

Thanks for your update. Since the issue is still occurring, let's check a few more things that might be affecting the total.

First, please verify if any report, page, or visual-level filters are applied in Power BI. Sometimes, the table visual may show a filtered version of the data, which could lead to differences when exporting. Hidden data, summarization, or aggregation logic might also impact the results.

Another factor could be how the measure is calculating the total. While SUM(Sales) should aggregate the column directly, implicit filters or calculations may be affecting the final total. As a test, try creating a calculated column instead:

Sales_Check = Table[Sales]

Then, sum this column in Power BI and compare it with the Excel total to see if there's a difference.

If the issue persists, it would be helpful if you could share PBIX file (or a version with sample data) along with the exact DAX measures used. This will allow us to take a closer look and provide more specific guidance.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Regards,
Vinay.