Secure Filter with value if column of other table

[fjcasadoa]

Hi, The column USR_MAIL from "Productos" is Ref to "Users", the column USR_MAIL from "Chat" is ref "Users" and he column PROD_ID from "Chat" is ref to "Productos".  What I need is to make a Secure Filter in the table "Productos" where bring only the rows that the Productos.[PROD_ID] = Chat.[PROD_ID] AND Chat.[USR_MAIL] = USEREMAIL()

Thanks for the Help

[WillowMobileSys · Accepted solution]

The expression should be something like:

IN([Prod ID], SELECT(Chat[Prod ID], [Usr_mail] = USEREMAIL()))

This works because you have set the USR_EMAIL as the key.  I do not recommend using emails as key values.  They can and do change.  If you do add an other column as the key, the you would simply replace USEREMAIL() with a LOOKUP() function that returns that key column. 

[fjcasadoa]

thanks very much....