PowerBI Export Data is different than the table visual

[aswathyjoe]

I am simply calculating the pay amount for each client and, on the grand total it shows 166461

But when I export the same data to excel, the total amount is different as shown below.  Can anyone tell me whats going on in here?

[amitchandak · Accepted solution]

@aswathyjoe , Couple of reasons.

1. Power BI does export more than 30K in csv and 150K in excel.

2. Power bi recalculate the Grand total, so in case you are using row context, it would not be a simple sum of rows

Refer why Grand total is wrong -https://www.youtube.com/watch?v=ufHOOLdi_jk