Forum Discussion

HB13's avatar
HB13
Icon for Helper I rankHelper I
4 years ago

Totals on Table visual vs Excel export do not match

Hi all   I have a Table in PowerBI desktop that is showing the Count (Distinct) of an item per Date created and per Type. The grand total of the counts displayed in my table is 158,238. However whe...
Need Help
Tips and Tricks
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
4 years ago

Whatever it is you are conting has entries in more than 1 row but in the grand total in the visual it is only getting counted onces.  When you sum up the lines on the export you are double counting the 100 things that are counted on more than 1 row of your visual.