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!