Show all data on table if user name not in the table

[Sagejah9]

Hi , I am trying to use dax logic to create the rls to filter a particular table. First I'm checking the username based on their access. I would like to filter the table to only the person if they are in the table otherwise the person gets to see all data in table. 

[v-henryk-mstf · Accepted solution]

Hi @Sagejah9 ,

Based on your description, I think you can configure dynamic rls by using the userprincipalname() function. Determine if the current user is in the table, and if present, allow access to the content. I did the test with the following reference.

if user not in table:

For more details, you can read related blog as below:

USERNAME() v/s USERPRINCIPALNAME() in RLS for Pow... - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.