Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Remove rows with single values in another column

Hi everyone,

I have a dataset of the following type.

ID            Attribute              Value

1.1            A                            red

1.2            A                            red

1.2            B                           red

1.3            A                            red

1.4            A                            red

1.5            B                             red

1.6            C                              red

1.7             C                             red

1.7              D                            red

 

 

I want to remove rows that are not repeated, and want to keep only those that have been repeated

I tried various filters but it didn't work.

What dax query would help filter the repeated ones out?

Thankss

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    If you can work in Power Query, you can choose to Keep duplicates rows:

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    If you can work in Power Query, you can choose to Keep duplicates rows: