Remove rows with single values in another column

Anonymous — Fri, 25 Nov 2022 10:16:02 GMT

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

Re: Remove rows with single values in another column

Anonymous — Fri, 25 Nov 2022 10:50:50 GMT

Hi Anonymous ,

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