I used the following to add row level security, however I modified the RLS DAX to the below IF/THEN statement. Any idea on how to get this working? A loan may have a primary or secondary LO or both. I want user C to be able to see records where the primary LO = A or the secondary LO = B. The Users - Secondary (2) table is referencing the Users - Primary table as it’s source. I’ve included my data model below to help.
I’ve been trying to schedule a call with Microsoft to resolve. I found a better example that would allow more flexibility in RLS. Upon inspection, it appears I’m getting inconsistent behavior depending on if I am using a work machine or my personal laptop, leading me to believe there is something bigger going on that is preventing RLS from working and not necessarily my DAX.