csv exports different values

[Anonymous]

check the image below. left is my original matrix visual. right is the exported CSV from the same visual.

the values dont match!

I have 3 levels of drilldown. I am in second level, using the second button for drilldown (2 arrows down) so I am ignoring the first level.

If I remove the first and third levels of drilldown from the matrix, the values match.

I understand this as an error on the export procedure.

[v-yuta-msft]

Hi DN,

Please check if values in table in power bi match CSV values because power bi visual will aggregate some values if other column is same.

Regards,

Jimmy Tao

[Anonymous]

Yes, totals are correct, but not the view I need.

Below, fast example of what is happening.

[v-yuta-msft · Accepted solution]

Hi DN,

You can't export the second level data into .csv because it's not your data source(original table). As a workaround, you can create a calculate table using function like summarize() or others.

Regards,

Jimmy Tao