RLS multiple combination with different levels

[La_Panic]

Hi there,

I would like to implement Dynamic RLS in Power BI adapting Corporate Heirarchy logic to Region Hierarchy.

I have 4 Levels listed folowing:

Country, East/west, State, Store

I have to manage different exceptions so you can notice that the user a@Group have access to two different levels means Level 2 East ( all the stores belonging to East region) also Store O1 this store is from the west Region.

Thanks for your help

My Tables

[kentyler]

Since your access levels cross over regions, I think the way forward will be easier if you multiply your store/sales combinations with the regions, so you have an access level id for each store/sale/region combination.
This is an interesting problem. I'd be happy to do a screen share and talk more about it. If you want, send me your email and a good time to talk. ken@8thfold.com

Power BI is easy to learn, but it has hard parts. I'm a personal Power Bi Trainer I learn something every time I answer a question How to Get Your Question Answered Quickly

[La_Panic]

Thanks kentyler,

I thought about this solustion but I have a constraint that could affect the performance:

1000 store * 4 levels also more than 700 users + many many exceptions ...

le me know if you think that this could be managed with your solution and the performance will be good ?

How to link my tables ?

Regards