Hello, could someone help me? I need to filter a slice in which the data of the column User[RotasUsuario] which is of type enumlist are common to the second table Rota[NomeRota] since UserEmail = useremail.
I did the following formula, but it didn’t work
IN(SELECT(User[UserRoutes],[UserEmail]= USEREMAIL()), Route[RouteName]). I tried the INTERSECT function too, but I got no success
Can you show your tables columns structure to better understanding?
2 Likes
Indeed, sharing your column structure would clarify what you’re seeking to accomplish.
Meanwhile, I wonder how you tried INTERSECT and whether the following approximates your need.
[RotasUsuario] = INTERSECT([RotasUsuario], SELECT(Rota[NomeRota], [UserEmail] = USEREMAIL()))
1 Like
I want to create a view in which users can only view the ROUTES they are registered
. Ex. Employee Antonio can only view Route 003- Januária , 037 - Salinas and employee Etiene can view ROUTE 034 - Bonito de Minas, 035 - Coração de Jesus, 008 - Chapada Gaucha, 000 - Galpão.
I tried this but it didn’t work. Gave error. I posted my table above.
[Rota] = INTERSECT([Rota], SELECT(Usuario[RotasUsuario], [EmailUsuario] = USEREMAIL()))
Try this formula in your slice:
IN([NomeRota], INDEX(SELECT(Usuario[RotasUsuario], [EmailUsuario] = USEREMAIL()), 1))
2 Likes
It worked, thank you very much. I just didn’t understand very well, the INDEX formula wouldn’t have to return only 1 value. In this case, it returns a list. Could you explain to me. Thank you very much in advance.
1 Like
YEs INDEX() return just a value, but the type of this value is a LIST, so IN function search the NameRota value in the list of User Rotas defined in RotasUsuario column.
ANY() function does not work for LIST types (I think its a bug)