Row level security two values

[Anonymous]

Hi team,
my table two rows and two columns

customer frequency
ABC daily
ABC intradate
both column are drop down slicer in my report
my problem is:
user name:shanvitha
view only ABC and daily data filters
another user only lavidiya
both values based on filters
when select customer its show ABC
frequency need show daily and intradate


how to achieve this

thanks
shanvitha

[d_gosbell · Accepted solution]

Create 2 roles, 

Role1 has a filter on your table with an expression like: 

table[Customer] = "ABC" && table[Frequency] ="daily"

Role2 has no filters applied.

Then you put shanvitha in Role1 and lavidiya in Role2