Forum Discussion

incicelikozu's avatar
incicelikozu
New Member
8 years ago

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 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

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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's avatar
      incicelikozu
      New Member
      8 years ago

      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.