Solved: Display Only Duplicate Values in a slice - Page 2

Sergio_Sa · 09-25-2019 06:25 AM

Hello everyone.
I have a table with a column called [Caixa]. This column has duplicate values.

I want to get a slice with only all the duplicate values in that column.
I swear I read all the posts about duplicates and couldn’t find a solution and I can’t figure out where MAXROW () can help me.
All help is welcome.
Thanks

Suvrutt_Gurjar

Hi @Sergio_Sa,

If I have understood your requirement correctly, you may wish to use following expression in the row filter condition of the slice settings pane to get such a slice of all duplicate or repeating values of the column [Caixa]

IN([Caixa], SELECT(Your Table Name[Caixa], NOT(IN([Key Column], LIST([_THISROW].[Key Column])))))

View solution in original post