Procedure set [email protected] can only view SOURCE=TS ?

Hi All

Refer to Below link is the instruction 

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613

At 10 min 11 sec , it mentioned manager field :-

Is Manager = 1

(1) Can only view SOURCE = TS AND TA ( Not manager )

SOURCE = TS , email = [email protected]

SOURCE = TA, email = [email protected]

(2) Can view all SOURCE  ( Manager )

SOURCE = TS , email = [email protected]

SOURCE = TA , email = [email protected]

SOURCE = SD , email = [email protected]

SOURCE = PW , email = [email protected]

SOURCE = PM , email = [email protected]

Manage role insert below code :-

if(

LOOKUPVALUE(

'SOURCE' [Is Manager],

'SOURCE' [Email],

USERPRICIPALNAME()

)=0,

[User]=USERPRICIPALNAME()

true()

)

This post only for my viewing , to understand how to set the above right ?

1ST i set up the email table and i link the=is table to my SOURCE TABLE field :-

2nd i careate the manage role :-

3th i publish the PBI file to web service to [email protected] site and i set the security membership for this PBI [email protected] and [email protected] , total 2 member

I thinking below step is very important , must add all member email here. 

when i test , i found it working as SOURCE only can view SOURCE=TS , may i know why ?

Next i try to share publish the same PBI file to [email protected] , just to see that can paulyeo site view only SOURCE=TA ?

Ans :- If i add paulyeo email to below RLS , then Paulyeo only can view SOURCE=TA . Now my question is , it is because i am admin of both site , that why i am able to set the security , and allow to add membership to this PBI at web serivces ? and it is correct that non admin mean when i share the PBI file to member , they ar unable to see the security setting ? 

Paul