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

Anonymous 

I am trying to refer the links but EARLIER function is not working.
please find image attached.

Could you please help me on this .

 

Thanks !

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Count Emails = 
Var Emails = [Emails]
RETURN

CALCULATE(
    COUNTROWS('Your Table'),
    all('Your Table'),
    'Your Table'[Emails] = Emails
)

You can try this one. Available in the 1st link Anonymous