RLS Issue when two True Values are found

[raul1]

Hi,

I'm having an issue to get my RLS function to work when for a specific use i get two true values.
Power BI apparentely bugs and keeps trying to load for 10-15min  then it says viasuals exeeded limits.

RLS Function: Country = User_Country
User_Country = LOOKUPVALUE('User'[Country];'User'[Name];[UserName])

Eg.: For Bob, i wan't to filer a list to show only the countries he should see. For John and JAck RLS works perfectly.

'User' List
Name            | Country
Bob                | US
Bob                | France
John               | China
Jack                | UK

Does anyones knows how to solve this?

I've tried to change the acesss list ot looik like this, yet it did not work:

Name             | Country
Bob                | US || France

Bob | US ; France

Thanks for your help!

[v-haibl-msft]

@raul1

I'm not sure if I understand your scenario correctly. Based on your description, if you have two tables with 1:* relationship as below.

You can try to define the RLS function like:

[Country] = CONCATENATEX( FILTER( User, User[Name] = [UserName] ), User[Country], " ; " )

Best Regards,
Herbert