Powerbi Excel Pivot Table Grand Total Difference

[JDeMaro22]

Hello,

I've read so many articles trying to explain this to me but it's still over my head. I created a pivot from our PowerBI data in excel and the grand totals showcases different numbers than my table. I understand that it's due to the value being a DistinctCount Measure but which is accurate the powerbi total or excels?

Thanks

[Karnik_]

Hi did you find any solution?

[lbendlin]

Yes.  🙂

It depends on your definition of "accurate",  and it depends on what insights you are trying to get out of your data.  Use what is most appropriate.