Forum Discussion

RafDelgado's avatar
RafDelgado
Helper II
7 years ago

Dynamic RLS role creation based on role name

Hi All,    Is it possible to have a dynamic RLS role filter based on the role name itself?   So for example:   Role name = '1677217' Table filter:  ID = [Role name]   Or   Role Name = 'New...
Need Help
  • RafDelgado's avatar
    RafDelgado
    Helper II
    7 years ago

    Hey v-lili6-msft , 

     

    Thanks so much for the reply. 

     

    I think I may not have explained it properly, What I would like is something like the below.

     

     

     

     

     

     

    But instead of the DAX expression being filtered on the manually typed 16777217, it uses the name of the role instead.

     

     

     

    Meaning I could have mutliple roles with different number ids for what I want to filter but not have to go through each table to change the query.