Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

RLS multiple combination with different levels

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 TablesMy Tables

Solution Sage
Solution Sage

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.



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 


Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!

Join the conversation at We Talk BI find out more about me at Slow BI

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 ?


Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.