PRLS with lookupvalue on 2 tables different

[huguo_90]

I have a table A I have a dimension table A containing the names and emails of managers and teams, I have a table made B with all the appropriate calculations. The problem is that when I implement the RLS, it finds all the team data, not the manager's data, but now I can't add the manager to the final data. Here is the code I used but it's not good.

IF (

    ISFILTERED ( 'A'[NAMES_TEAM] ),

    'A'[NAMES_TEAM] = USERNAME() || 'A'[MAIL] = USERPRINCIPALNAME(),

    'A'[MAIL] = USERPRINCIPALNAME() && 'B'[TEAM] = LOOKUPVALUE('A'[TEAM],'B'[MAIL],USERPRINCIPALNAME())

)

[huguo_90]

Hello @Mahesh0016 , Thanks to answer me, When I make a filter on the size table I only see the people of the Pierre team but I do not see see Pierre so in the dashbord I do not see his income, I would like to see the revenues of Pierre and his are teams, I try by putting a double relationship on it but it does not work. Hope you manage to understand my drawing.

[Mahesh0016]

@huguo_90 Please Share your Expected Output in Table.
THANK YOU!!