Find a list rows with duplicate ID

[Leebc]

Hi,

I'm new to Power BI and DAX.
I'm trying to find and list all rows in the table which have the same ID (Field/column). What would be the easiest or least complex way to search through the data in a filed and to extract or list all the rows with the same or duplicate ID

Cheers.

 

[MarcelBeug]

In Power Query: Edit queries - Keep Rows (slightly right to the middle) - Keep Duplicates

In fact there is no function to keep duplicates, but this option will create some code for you, for example (I structured it a little so it's easier to read):

= let
    columnNames = {"Number1"},
    addCount = Table.Group(SampleData, columnNames, {{"Count", Table.RowCount, type number}}),
    selectDuplicates = Table.SelectRows(addCount, each [Count] > 1),
    removeCount = Table.RemoveColumns(selectDuplicates, "Count")
   in
    Table.Join(SampleData, columnNames, removeCount, columnNames, JoinKind.Inner)

PQ alternatives: Group By, Sort.

DAX is not my specialism.

 

[Leebc]

Thanks MarcelBeug, I will try this out.