Security Filter formula anomalous behavior
I have a table, Tasks, with two columns:
a ref to another table, Project and
Project Name which is [Project].[Project Name]
Projects has a column UserList which is an EnumList of BaseType Email.
I am seeing a difference in results between the following two where I expect none. What am I missing?
IN(USEREMAIL(), [Project].[UserList]) - does not work, filters away everything
IN(USEREMAIL(), SELECT(Project[UserList], [Project Name]=[_THISROW].[Project Name])) - works, filters rows only intended for user