RSL implementation..

[kanth123]

Hi,

I set up RSL using intermediate table and relationship. Intermediate table has employee name,Location and region. Below is the structure of intermediate table. 

RSL working  at employee level. 

And i need help in set up to access to Manager and Regional managers. Manager and RM were not part of intermediate table. 

Managers:

Bob - SW, Sue - SE ,Mike - SW

RM:

Jeff - E, Ross - W

Any idea how this can be done. 

Intermediate table.

Employee	location	Region
a	NE	E
b	NE	E
c	SE	E
d	SE	E
e	SW	W
f	SW	W

Thanks in advance..  

[lbendlin]

we are using that approach with thousands of users, and we do not see performance issues. We do have an external database (external to Power BI) that does the mapping for us.

[lbendlin · Accepted solution]

One approach is to add the regional managers to the intermediate table multiple times, for each of the locations in that region.

[kanth123]

@lbendlin. This approach works well when # of users is less. This gets more complex to maintain if we have more users. Is there any better approach.