Does Filter(Unique()) work on tables?

[Dazzathedrummer]

Hi,

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")

[#2 · Accepted solution]

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

Something like this:

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

[#3]

@Dazzathedrummer 

The count of the items is not equal.

Check:

=COUNTA(Unique(Table1[Column1]))
=COUNTA(Table1[Column1]="ABC")

[#4]

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