Problem with Dynamic RLS Security

[pbi1908]

Hi all, 

I have a table with Customers and a table with Traders. One Customer can have multiple Traders so in the Traders table i have a foreign key which is the Customer ID and one to many relationship in the Data Model.

I have a matrix visual in which in the Rows Hierarchy i have first the Customer Name from Customers table and then another four columns from other tables. I have the Trader Name as a slicer so when i filter with a trader i see only his Customers. 

I will share this report with the Traders and i want to apply dynamic Row level Security because each trader must strictly see his Customers.

In the Traders table i have the Trader mail, so i am trying to create a role in which i add as an expression 'Trader[EMAIL] = USERPRINCIPALNAME()'. When i am trying view the report as a traderi realized that i still can see all the Data and the only difference is that in the slicer i can only filter with the name of this trader but my goal is to filter the whole report with the data of this trader when he access the report and not to see everything and filter it then if he want. 

In the meanwhile in the matrix visual i do not have any column from traders table. 

Can anyone help me on this ?

[Alex_Sawdo]

I think you are missing something with the relationship between your tables. When you check the relationship, do you have "Apply security filter in both directions" checked or un-checked? You would need to do this for tables that don't have it selected. Also, I'm not 100% sure but the casing of the email might matter so try writing your filter like this: UPPER('Trader'[EMAIL]) = UPPER(USERPRINCIPALNAME()).

[pbi1908]

No actually what i missed was to enable the both direction in security within the properties of the relationship.