Count unique IDs with a wildcard criteria for another column

[ausswe]

Hi,
I'm trying to count unique IDs in a table with ID and Resource as two separate columns. In this case I need to count any resources that contain "land" in the resource name (can be anywhere in the resource name).

I have been searching around and came across the UNIQUE and FILTER function for O365 and have tried the following but it shows as an empty result:

=COUNT(UNIQUE(FILTER(SOL[ID];ISNUMBER(SEARCH("land";SOL[Resource])))))

I have also tried:

=COUNT(UNIQUE(FILTER(SOL[ID];ISNUMBER(SEARCH("land";SOL[Resource];1)))))

Any thoughts on where the formula is wrong?

Thanks in advance!

 

[Phuoc]

Try change COUNT to ROWS:

=ROWS(UNIQUE(FILTER(SOL[ID];ISNUMBER(SEARCH("land";SOL[Resource])))))

 

[ausswe]

Thank you so much - that worked!