Forum Discussion

urpalani's avatar
urpalani
Helper II
9 years ago

RLS - for default Value Show all

Hi,   I have Role based Secuirty using Lookup,When 'America' is the access then america data should be shown ,Same for Asia also , But If i want to show both data ,I want to mention 'All' instead ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi urpalani,

 

As you already created RLS role for the dataset, to let a user to view all data, please create a role (named "all")  without any filter applied, then add the user as a member of this role.

 

 

Please note if you add the user as member of role you created before, and also add this same user under the role (all), this user will see all data when he view the report.

 

Best Regards,
QiuyunYu

urpalani's avatar
urpalani
Helper II
9 years ago

Hi v-qiuyu-MSFT,

 

Ok if i have one level security,

 

But in my case i have two level of security,In second level instead of mentioning the values,I will mention as 'ALL' ,then lookup should show all the values for second level security,

 

Example,

Country - First Level

City - Second Level

 

If I mention Certain city then certain city of the country should show,but if i want to show all city of the country i will mention as 'ALL',So how to handle this in DAX Lookup