Not same number of rows after creating new table

[Pbiuserr]

Hello,

I've imported 6,202,519 rows from my cloud, and I want to get two columns - ID and DataCod from this table. When I do SUMMARIZE/SUMMARIZECOLUMNS with these, I got 6,202,517 rows as a result. How to see which entires have been omitted, and why does it happen? It supposed to transfer all of them, as far as I know?

Thank you in advance

[johnt75 · Accepted solution]

Its possible that there are duplicate entries in your source data.

You can see which, if any, rows have been omitted by creating a table like

Missing rows = EXCEPT(
SELECTCOLUMNS( 'Source Table', 'Source Table'[ID], 'Source Table'[Code]),
SELECTCOLUMNS( 'Summary Table', 'Summary Table'[ID], 'Summary Table'[Code])
)

and you can see if there are any duplicates by creating a measure like

Num Rows = COUNTROWS('Source Table')

and putting that into a table visual with the ID and Code from the Source table, sorted by num rows descending

[Pbiuserr]

Hello @johnt75 ,

Missing rows table gives no result, as the unique values are the same in both tables. I dont know, should I try add every next column to SummaryTable and see in which number of rows increases?

EDIT: I've managed to run countrows on the datecode and see where is discrapency, then add layer of ID and sorted descending, getting one ID having 2 entires instead of 1. Thank you very much!