Hi all,
I have a problem understanding di IN() expression.
I have a table where are stored many records and every row is associate to a "FIELD".
Then I have a table where are associated a referenced row of table USERS and a referenced row of table FIELDS.
In the first table, I have created a virtual column with this formula to verify if what I'm doing it's right:
LIST(SELECT(Utenti_Fields[ID FIELDS],[ID UTENTE].[USERNAME]=USEREMAIL()))
And correctly the value is "11, 12, 13" because the user who is signed has these 3 fields associated.
Then I tried to add the IN() expression to this formula, modifying it in IN([ID FIELD], LIST(SELECT(Utenti_Fields[ID FIELDS],[ID UTENTE].[USERNAME]=USEREMAIL()))) and added in the security filter of the first table or in a new slice in the row filter condition.... but the result is nothing !!!
Why it doesn't work ?
LinkedIn
Twitter
