Remove rows with single values in another column

[muhamazh]

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

[Luis98 · Accepted solution]

Hi @muhamazh ,

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