Manager Level Security with Two Tables applying Dynamic Row Level Security

[pylon350]

Hello everyone! 

I need help implementing a Dynamic Row Level Security on two different tables to filter by managers. The RLS should be applied to give permission for high level users to be able to see all data while the public can only see the noncofidential documents. The first table contains the management information such as the email and if they are allowed to see confidential documents or not, and the other table conatins the documents in one column and their confidentiality status in another column. 

"Y" in the first table indicates if the person should be able to see confidential documents, and "Y" in the second table indicates if the document is confidential, and vice versa. 

The two tables are connected with a many-to-many cardinality through [confidential] column, as follows:

I created two roles, one for the public to not show the confidential docs and confidential role to show them.

The DAX expressions are: 

This is working only if I view it as Public or Confidential; however, when I am trying to put an email address to view it as another person, it is not working as it supposed to be. Same thing after I published it. 

Could you please tell me what I am doing wrong? Could it be the users filter expression is not applied properly because I'm only filtering Table 2? 

Is there a way to overcome this issue? 

Thank you in advance