Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Display only repeated number

Hi, I want to create a column which ID's are repeted from column ID.   Id Type Status RADOC0010024 RAD Cancelled RADOC0010024 RAD Cancelled RADOC0010056 RAD Cancelled RADOC0...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Create a calculated column on original table.

    Column = CALCULATE(COUNT('Table'[Id]),ALLEXCEPT('Table','Table'[Id]))

     

    Then create a new table and filter out the records which count <=1.

    Table 2 = DISTINCT(SELECTCOLUMNS(FILTER('Table','Table'[Column]>1),"id",'Table'[Id]))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

Create a calculated column on original table.

Column = CALCULATE(COUNT('Table'[Id]),ALLEXCEPT('Table','Table'[Id]))

 

Then create a new table and filter out the records which count <=1.

Table 2 = DISTINCT(SELECTCOLUMNS(FILTER('Table','Table'[Column]>1),"id",'Table'[Id]))

 

Best Regards,

Jay