USERPRINCIPALNAME DAX for Proxy Users in RLS

[cv2qm]

Hello Community,

I am trying to implement proxy users for RLS. If proxy user has logged into power bi, he has to see the assigned user data. 'RLS Proxy ' table I am trying to do this by DAX. I tried with IF, Contains and several other functions.

I can't see expected result.

Can anyone guide me how i can achieve this by using below sample data. RLS Proxy table

UPN	Proxy UPN
gfb7c@Domain.com	ach3q@Domain.com
twd2e@Domain.com	cv2qm@Domain.com
bea4k@Domain.com	ac7xa@Domain.com
drb7c@Domain.com	abcg6@Domain.com

Expected result: IF(USERPRINCIPALNAME() = CONTAINS('RLS Proxy','RLS Proxy'[Proxy UPN])),

Then--> Get UPN value assigned,

Else--> USERPRINCIPALNAME())

Thanks

VCK

[amitchandak]

What is purpose of - CONTAINS('RLS Proxy','RLS Proxy'[Proxy UPN]))

[cv2qm]

Checking UPN is existing aren't in RLS proxy table. If logged in UPN is listed in RLS proxy table, then get assigned UPN.