SUM rows

[incicelikozu]

When a Power BI table is exported into an excel file, sum values in upper levels are not matching between Power BI view and Excel file. The reason might be values cannot be counted as distinct in excel and it sums up the values automatically. Can anyone suggest to solve this problem? Many thanks. ( I attached 2 screenshots)

Power BI ViewExcel View

[v-yulgu-msft]

Hi @incicelikozu,

As I know, it is not available to export exactly the same visual from Power BI desktop to Excel. How did you get the result in second screenshot? Besides, it looks like the correct value of grand total shoud be 329 (139+95+95). So how did you get 176 in Power BI view?

Regards,

Yuliana Gu

[incicelikozu]

It is counted with “count (distinct)” function. Duplicated values in total row are eliminated. And all cases are unique in Total. That’s why. I hope it is clear.