Does Filter(Unique()) work on tables?

New Contributor



I think the array formulas are great but I can't get the filter function to work on table columns.


For example - if I do =Filter(Unique(Table1[Column1]), Table1[Column1]="ABC") I just get #VALUE!

Am I getting the formula wrong or does Filter() not work on tables?


Being able to filter on associated table columns would be great - =Filter(Unique(Table1[Column1]), Table1[Column2]="123")

3 Replies
best response confirmed by Dazzathedrummer (New Contributor)

@Dazzathedrummer You need to place UNIQUE outside the FILTER function.

Something like this:

=UNIQUE(FILTER(Table1[Column1], Table1[Column2]="123"))





The count of the items is not equal.


That's fixed it!
It seems so obvious when you see it - thanks!