Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Row Level Security and Slicer

Hello Experts,   I am stuck with one problem and need your guidance.   I have a table and it has 4 departemnts like 10,20,30 and 40. I have set the RLS with each departments respective managers s...
Show and Tell
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    You may add the following DAX filter expression.

    || LOOKUPVALUE ( Table1[dept], Table1[shareddata], Table1[dept] ) = 10
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

You may add the following DAX filter expression.

|| LOOKUPVALUE ( Table1[dept], Table1[shareddata], Table1[dept] ) = 10