Find duplicate values in the slicers context

[Anonymous]

Hi!

I've been spending my day banging head to the wall with this problem. I need to check if value is a duplicate of value in the same column that is filtered by slicer.

Slicer	Part code	Has duplicates
1	14	FALSE
1	15	FALSE
1	16	FALSE
2	14	TRUE
2	15	FALSE
2	16	FALSE
2	14	TRUE

I was going for the COUNTROWS with EARLIER, but I'm unable to keep the correct context. I keep getting the false positives for the part codes that are being used by a different slicer.

Thanks in advance!

[spuder · Accepted solution]

Hi,

my first thought was to concatenate both columns and then start the count with earlier.

Have a look at my screenshot

[Anonymous]

Hi,

Thanks! That is so simple and effective.