Forum Discussion
Filter a visual using the Role name
Anonymous - If I understand correctly, you do have to build it into each role. For example, I created an ITA role
RLS Rules
Countries - [Country] = "ITA"
Table - [ORIGIN_COUNTRY] = "ITA" || [DESTINATION_COUNTRY] = "ITA"
I realize that you were essentially kind of wanting to avoid this but I do not see another way because from what I can tell, RLS rules between tables get "anded" together. Maybe if you kept Countries disconnected and made your rules this:
Countries - [Country] = "ITA"
[ORIGIN_COUNTRY] = MAX('Countries'[Country]) || [DESTINATION_COUNTRY] = MAX('Countries'[Country])
Then you would only have to hard code "ITA", "USA", etc once for all of the roles and the other RLS role would be exactly the same between roles.
I see. Well, thank you very much for the help Greg_Deckler ! It was very helpful!
- Hope were were able to get to a resolution Anonymous !
I've only one last problem, Greg_Deckler : if I change the visual from table to multi-row card (showing some other data I haven't included in this example), the filter where measure = 1 doesn't work anymore: the menu gets frozen and therefore by defauls selects both measures 0 and 1. What's going on?