RLS value to match value in row

[Anonymous]

Suppose this is my table called "People"

I want to set up a role that says "You can only see data about other people from the same country as yours".

Is there not a simple DAX for this?

[Country] = <the same>

[Greg_Deckler · Accepted solution]

You would need to use something like LOOKUPVALUE(...) = [Country] where your LOOKUPVALUE would use the Name to lookup the user's country.

[Greg_Deckler]

You would need to use something like LOOKUPVALUE(...) = [Country] where your LOOKUPVALUE would use the Name to lookup the user's country.

[Anonymous]

The report has email and uses USERPRINCIPAL() extensively. Does that make it easier? 

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Row-level-security-to-see-organization-data-for-different-users/m-p/372051#M168773

[Greg_Deckler · Accepted solution]

You would need to use something like LOOKUPVALUE(...) = [Country] where your LOOKUPVALUE would use the Name to lookup the user's country.