Dynamic RLS not working for two columns

[Balhemkan]

Hi Team,

I have created dynamic RLS on powerbi

In table i have 3 columns

Type      Country sales

B2B       India     10

B2C       India   20

B2B       Germany 10

B2C       Germany 20

Dynamic RLS table I have created like this

Type      Country User

B2B       India     A@xyz.com

B2C       India   b@xyz.com

B2B       Germany c@xyz.com

B2C       Germany d@xyz.com

Because of many to many i have created bridge table for Country

Country

India

Germany

I have created role saying Dynamic = userprincipalname()

when I test the role for a@xyz.com he can see only "India" data but he is seeing for both B2B and B2C

we don’t want him to see for B2C we need to show him only for B2B India.

Could you please help me who to achieve this.

[Balhemkan]

@amitchandak

@SpartaBI 

@Ashish_Mathur 

@speedramps 

@parry2k 

Could you please help me

[amitchandak]

@Balhemkan , The above two should join in a combined key

new column in both tables

Key = [Type] & "-" & [Country]

[Balhemkan · Accepted solution]

@amitchandak - Thanks a lot Amit. You are really genius. When ever I need help, all my questions I got answers from you.