How to display duplicates in a Filtered View?

[cjphoto]

Hey there! I'm trying to create a filtered view that will display any duplicate addresses in my app. I tried this expression but it did not work. Is this possible?

LINKTOFILTEREDVIEW("Admin View",
[Full Address] = [_THISROW].[Full Address])

[AleksiAlkio]

Are you trying to show dublicates for a specific row or showing that view for all rows?

[cjphoto]

I'm trying to show the duplicates for all rows.

[AleksiAlkio · Accepted solution]

One way is to add a virtual column checking if there are more than one row with the same column value and then use that like LINKTOFILTEREDVIEW("YourView",[Duplicates])

[cjphoto]

Ahh I see okay I'll give that a go, thanks very much!