Double values from distinc count

[Anonymous]

Hello all,

The  column CustomerAccountnumber contains 26.568 rows which 26.567 rows are distinct rows (see image below). 

How can i f find the rows that has the same values in this column?

Thanks in advanced! 

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may try to add a column to get the count column. For example:

Column =
COUNTROWS ( FILTER ( Table4, Table4[Column1] = EARLIER ( Table4[Column1] ) ) )

Regards,

Cherie