Forum Discussion
SUM rows
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 exc...
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
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.
