Record count not matching after creating new table

[PowerBINoob24]

I have a table that was created from an excel file data source.  One of the fields contains email addresses, and when I create a card visual and do a count of email addresses I come up with 162,160 email addresses.  I then created a second table using  =SUMMARIZE('table name', table name[Email Address]).  I created a card visual using the second table, but the number of email addresses comes out as 162,147.  What would be causing the difference?

[Nathaniel_C]

Hi @PowerBINoob24 ,

Duplicate email addresses.  BTW look into using SUMMARIZECOLUMNS() rather than SUMMARIZE().  Microsoft realized they had a bug in SUMMARIZE() and created the new function.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[adudani]

@PowerBINoob24 ,
Summarize will group  the table name by the e-mail address.
so when you take the count of this, it is only of unique values.

try taking the distinct count in the first table and see if it matches for confirmation.

Please let me know if this resolves your query.

Appreciate a thumbs up if this is helpful.

[PowerBINoob24]

Not sure if I'm understanding how summarize groups the table name by the email addresses

Okay....so If I do a count of distinct they match at 43,767.   Still not understanding what would be causing the difference of 13 records when just doing a count. Also now wondering if I should be relying on the orginal table data or the data feeding into the new table I created.

[Nathaniel_C]

Hi @PowerBINoob24 , @adudani ,
On your original data, do a distinct count on emails. I might do it also on another col, like client id or whatever you have. That might give you some insight.  Then if you wish you can remove duplicates.  That is if I understand your issue.  You might try it again, like I said with SummarizeColumns().

Good Luck!

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

[PowerBINoob24]

I went into power query for the table and did a "keep "duplicates" and it comes back with no duplicates, so it seems like there are no duplicates.