Toggling dynamic row level security

I was able to work out a solution by adding another dimensional table and applying RLS against that.

• I applied bidirectional filtering to the new table, but did not apply security in both directions.
  • This way, with RLS applied to DIM_Cost_Center, I start with only the cost centers that each employee is permitted to see.
  • This table then filters which cost centers are accessible from DIM_Cost_Center_Selection[Selection]="All".
• The second RLS filter limits which records are visibile in DIM_Cost_Center_Selection[Selection]="Mine"

Now I'm able to throw slicers on the canvas where the end-user specifies DIM_Cost_Center_Selection[Selection] and all visuals (including additional slicers) update accordingly.