Exported Data with Wrong Values/Total

Hi Anonymous ,

If the visualization uses data from more than one data table, and no active relationship exists for those tables in the data model, Power BI only exports data for the first table.

According to your description, Table(3) is filtered by Table(1) and Table(2) filters Table(1). The relationships among three tables are active, so when you add the ClientID of Table(1), you can get the correct exported data.

But when you remove the ClientID (table 1), there is no active relationship exists between Table(2) and Table(3), and the “sum of revenue of the clients” is filtered by ClientID (Table1), leading to  the sum of revenue of any store in the excel data changing to wrong values. 

I suggest that you can establish the relationship between Table(2) and Table(3) or make the relationship between them active, and then try to export to data.

Please refer to the following documents.

Export data from a Power BI visualization - Power BI | Microsoft Docs

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.