Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Double values from distinc count

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! 

 

 

Need Help
Show and Tell
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    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

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    8 years ago

    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