Dynamic RLS with 2 different filter levels

[tdhlonghorn]

Hello,

I'm trying to install Dynamic RLS (using Radacad's guidance linked below) for two different levels of access; some of my users will require access specific to certain account numbers, while others will need broader access to a rollup of accounts called "Abbr P&L." The filter works perfectly for Abbr P&L, but it's not working at all when I test users for AcctNum. What am I doing wrong? Sample .pbix is also linked below.

Dynamic RLS Test

Radacad

[parry2k]

@tdhlonghorn there are two issues that need to be fixed.

DAX for DynamicUserAccount need to be updated as below

[AcctNum] IN SELECTCOLUMNS(
FILTER(
'RolesAccount',
RELATED('User'[User]) = USERPRINCIPALNAME()
),
"AcctNum"
,[AcctNum]
)

and the relationship between the user and Role Account need to be as shown below

Fixed pbix is attached.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[tdhlonghorn]

Thanks for the reply @parry2k. Thanks to your advice I noticed I didn't set up the User table appropriately; I accidentally put the AcctNum instead of the Role. I've made the update to the source file and left my relationships and code intact; unfortunately the testing is still not working. Your method works as intended when I test it, but I prefer entering the text field (i.e. Warehouse B) in the User table because that Role (Warehouse B) could have multiple AcctNums associated with it.

Updated .pbix

Also, any hints for how to upload files directly instead of using dropbox would be amazing :).

[parry2k]

@tdhlonghorn Unfortunately you have to use external sources to share the file. I couldn't download your latest files, can you double check the link. I will try to take a link, I'm not fully sure from your message what you are looking for but maybe after looking at the file I will have a better understanding.

[tdhlonghorn]

Thanks @parry2k.  Trying again with the link here.