I am new to DAX and am trying to implement some dynamic RLS. The current table of users details looks like below:
| User Email | User Name | Agent ID | Level of Access Required | Region | Company |
| test@xxx.com | Test123 | 123 | Individual | USA | Company1 |
| test@xxx.com | Test456 | 456 | Regional | UK | Company2 |
| test@xxx.com | Test789 | 789 | National | AUS | Company3 |
What I want to do is give a user access at a level defined in 'Level of Access Required'.
This has 3 options:
1) National which will show all data for the specific company
2) Regional which will show all data for the specific company and the region
3) Individual which will show all data for user with the Agent ID
This table mentioned above will then be joined on to the other datasets within the report using a many to many join relationship I imagine?
Let me know if any further information is required.
