How to apply dynamic Row level Security based on Username and location

[Deepesh_V95]

Hi all,

I have a certain scenario where I have to apply dynamic RLS. Here is the case- I have a user table

A location table

And a Sales table

I want to apply Row level security that if a certain user logs in using the Email he should not only see his data but also all the users who are also in the same location. So if you can see in above User table, UserID 1,2,3 all are from location 1(i.e. User 1,2,3). So if user 1 logs in he should see the data of all the people who are in location 1.

So please suggest how to apply Row level security for this scenario? What DAX formula or logic needs to be applied here?

Thank you!

[v-chuncz-msft · Accepted solution]

@Deepesh_V95,

You may check the post below.

https://community.powerbi.com/t5/Desktop/Row-level-security-to-see-organization-data-for-different-u...

[Deepesh_V95]

Thank you Sam, that was helpful.