DAX Dynamic RLS

[Anonymous]

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.

[Stachu]

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5

you will have to pass the filters from this table to the other tables in the data model, joins are one option to do that, but you could also use FILTER, etc.