I have a security filter on a table called “ServiceTicket” using the following expression:
AND([Date]>=TODAY()-90, IN(SELECT(Local employees[TechnicianUseremail], [Division]=“Door”),[Assigned to]))
I have recently changed the [Assigned to] column in the “ServiceTicket” table to an Enumlist that references another table called “Local employees”. The “Local employees” table has a key column called [TechnicianUseremail].
The purpose of the security filter is to show any record where a value in the ServiceTicket Assigned to column matches any of the Local employees rows selected by way of TechnicianUseremail column where the Division column equals Door.
My issue is the security filter doesn’t actually show anything. It’s not the [Date] portion - if I isolate that portion the filter works.
I feel like I’m missing something simple but I can’t quite figure it out. My first thought was my select statement in context of IN isn’t workable. If I wrap the Select statement with Any I do get some records showing. That makes me think this issue is there.
Has anyone solved a similar/same problem before?