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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |