Row level security - Filter a table when many to one relationship

[DarylRob]

Hi, 

I've got two tables as below and i'm using row level security to filter on "Sales Associate", I then want this to filter all tables in the "Results" table by "Sales Rep"

So when I use row lvel security the peg table will be a one to many relationship but when not filtered it's a many to many relationship so doesn't seem to work. Any ideas?

Peg Table

Sales Associate	Sales Rep
Gary	Billy
Gary	Terry
Tim	Jill
Tim	Billy
Tim	Jim
Sandra	Terry

Results:

Sales Rep	Deal Name	Revenue
Terry	Deal 1	10
Terry	Deal 2	20
Jill	Deal 1	30
Jill	Deal 2	100

[v-yalanwu-msft · Accepted solution]

Hi, @DarylRob ;

1.One way is to change the direction of the relationship between the two tables to both.

2.Another option is to use DAX statements on row-level security.

在多对多关系中 - 第 1 部分，

在多对多关系中 - 第 2 部分。

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DataInsights]

@DarylRob,

This article explains how to handle a many-to-many relationship in row-level security:

https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi