How to Toggle RLS using a Slicer?

[jt197b]

Hi,

I'm trying to implement a RLS "toggle" to switch RLS off and on for a role. Basically, if RLS is on, the view defaults to display only the user's information.

If it is off, then the user can see all the information in the table.

This is the DAX expression I'm using for my RLS:

As you can see, it's a simple formula. But the toggle isn't working.... its hiding all data no matter what. Can anyone please assist?

Thanks!

[bcdobbs]

You might be able to adapt this approach which has RLS applied to a disconnected table and then uses a calculation group which could be switched on and off to pass the filter.

https://dobbsondata.co.uk/2022/03/08/calculation-groups-and-rls/

[v-jingzhang]

Hi @jt197b 

I'm afraid this is not possible. The table filter DAX expression is applied to the table where you set it. It evaluates every row in the table but it's not able to get the selected value from a slicer. Slicers and filters in the report cannot affect this DAX expression, so selectedvalue() function always return blank. It's just similar to creating a calculated column in the table, which only considers the row context and cannot be affected by user interactions with slicers/filters in the report. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.