Help with RLS

[gdps_vc]

Hello everybody! Hope someone can help me with this problem:

I have a table with various employee information, named Employees.

Registration Code	Name	Area	Entity	Cost Center

I also have a table with HR BPs by service area/entity, named BP_Entity

BP Name	BP Email	Area	Entity
name1	name1@company.com	HR	People
name1	name1@company.com	HR	Rewards
name1	name1@company.com	HR	Benefits
name2	name2@company.com	Logistic	Inboud
name3	name3@company.com	Logistic	Warehouse
name4	name4@company.com	Sales	Marketing

Both tables are connected by the Entity column.

I created an RLS on the BP_Entity table using [BP Email] = Userprincipalname(), and managed to ensure that the BPs only see employees from their respective service entities.

But here's the problem. An Entity has several Cost Centers.

Entity	Cost Center
People	1111
People	2222
People	3333
People	4444

I need BPs to see employees from their respective service entities, but also all employees from the 1111 Cost Center, from the People entity.

How can I solve this situation?

Best Regards

[lbendlin]

Change your RLS rule DAX accordingly?