How do you do conditional RLS

[markpatton]

I am trying to do a conditional filter on my data. I have a simplified set of tabels to illustrate what I am trying to do. This needs to be done with RLS to filter the data. 

I am using a user table for RLS to limit the transactions seen by a user.

This is my model. Just using a simple table to bind the users to transactions. A transaction can be bound to multiple users.

This works fine, But I want to do secondary filtering on level. For example, when I view as user.three@email.com I don't want to see level two transactions. This is based conditionally on the user level set in the user table.

I tried doing something like this but it did not work

Basically, I dont want a user to login and see level 2 transactions if thier user level is level 2. Level 1 users should see everything. 

Mark

[markpatton]

Link to PBIX

https://drive.google.com/file/d/1DWND4Ru0bNosJrd5dxsfbbkyU3hJCAf3/view?usp=sharing