Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

csv exports different values

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...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

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's avatar
Anonymous
Not applicable
8 years ago

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

Below, fast example of what is happening.

 

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    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