Show only rows with the same value

[Moniek]

Hi

I have a table with many transactions including date, amount, description and other columns. Now I want to see only the lines with the same amount? How can solve this?

Thanks

[amitchandak · Accepted solution]

@Moniek , create a new column

cnt = Countx(filter(Table, Table[Amount] = earlier(Table[Amount])) , Table[Amount])

You have filter cnt> 1 in visual

[Moniek]

Super thanks @amitchandak !