Security Filter formula anomalous behavior I...

[Bellave_Jayaram]

Security Filter formula anomalous behavior

I have a table, Tasks, with two columns:

1. a ref to another table, Project and

2. 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

Thanks.