Powerbi Excel Pivot Table Grand Total Difference

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