How to handle Power BI row Level security with "ALL" as a Mapping Value

[Anonymous]

Hello All,

I have three source tables and the data as shown below.

Sales Table:

User Table:

User Group Table:

Here I Want to Implement row Level Security. To do so, I have changed the user Group Table comma separated value to new line like below.

Finallly, Created relationship between tables "User Table" -> "User Group Table" -> "Sales Table". And Role as shown below

With this Approach the RLS is working fine for User1, User2 & User3. But not for User4 as there is no mapping for the Value "All".

How to handle this scenairo ? Here, user4 need Access to All the stores in the Sales table data.

Appreciate all your response.

Regards

[Anonymous]

Hi @Anonymous ,

You could create a role without any filter in it , then add user in that role.

Best Regards,

Jay

[Anonymous]

But My question is not About the Roles. I Need to use the given tables in the Scrrenshot.
This will not solve the purpose of it

[amitchandak]

@Anonymous , I am not sure You made the comma separated list worked. But all should be a list of all user; comma separated.

This what I DO

User , Group

A Group1 

B Group 1

All Group 4

User , user All

A A

B A

A All

B All

I merge the two and get rid of All, then can remove distinct and can create comma separated list

[Anonymous]

@amitchandak Can you help me with dax query to get the values programtically 

User , user All

A A

B B

A All

B All