I am new to power BI DRLS, would like some help in below scenario.
Scenario: One user can have access to many locations and one location can be access by many user.
For example User A can access sales data for Edinburgh, Glasgow & Bristol and user B can access Glasgow, London & Bristol
Location table: This table has four level hierarchy MD > Country > Region > City, path column has been populated by DAX PATH ()
User Table: This Table contain user and their email id
User_profile Table: This is bridge table and hold relationship between user and their location, with many to many relationship. One user can have access to many location and one location can be access by many users.
Fact_Sales Table: This contain sales data at location (City) level.
Can someone please help to implement DRLS in this scenario?
Thanks for your reply, the article which you referred is different from my scenario. IT does not include hierarchy with M-2-M relationship.