RLS with calculation group in a slicer

[PowerEti]

Hello,

I have a slicer based on a calculation group, it shows:

vs ACT

vs BUD

vs LE1

The column name is Name and the table name is CompPhase.

How would you remove "vs LE1" in the slicer from a view created for a particular region "California" ?

Is there a way to achieve that with a workaround since Calculation Group is not applicable with RLS ?

Thank you in advance,

[Anonymous · Accepted solution]

HI @PowerEti,

Perhaps you can add a custom table to mapping username and these fields values to link the source table fields that slicer used. Then you can set additional RLS filter on new table based on username and use relationship to apply the filter effects.
Regards,

Xiaoxin Sheng