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
Solved! Go to 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.
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.
thanks very much....
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |