Filter out column not in reference table

[Tom_automated]

I have a behavior that I do not want to show if the referenced Title column is not found in the referenced table . I’m having some difficulty constructing the correct filter statement.

My table:

The table being referenced is Form Responses:

So if Title in Gcal does not appear as the UNIQUEID in Form Responses I do not want the behavior to appear.

I’ve tried this FILTER("Form Responses", ([_THISROW] = [UNIQUEID])) but get this error:

The expression is valid but its result type ‘List’ is not one of the expected types: Yes/No

[MultiTech]

Tom_automated:

I have a behavior that I do not want to show if the referenced Title column is not found in the referenced table

What behavior are you trying to stop?

---

Maybe:

NOT(IN([Title], Form Responses[UniqueID]))

[Tom_automated]

The NOT IN statement does not work for me. I went with

OR(
    COUNT(FILTER("GCal",[_THISROW].[_name]=[_name]))>1,
    COUNT(FILTER("GCal",[_THISROW].[Location]=[Location]))>1
)

The behavior is a LINKTOFILTEREDVIEW(“GCal_Inline”, [_THISROW].[_name] = [_name]). The filtered view shows all meetings with a particular person … but since my calendar is linked to Google calendar some meetings are not rows in the referenced table (nor should they be), they are just meetings created via Google calendar.