Pass comma separated values in RLS

[prat1507]

HI

I need to pass comma separated values into my RLS. I have a table as 

ID, Fruits, Prices

1, Apple, 10

2, Banana, 20

3, Mango, 40

4, Kiwi, 50

I want to write a DAX which filters out the dat if I pass Apple,Banana in my RLS. I would also want to pass the IDs, for ex. 1,3.

Regards

Prat

[v-qiuyu-msft · Accepted solution]

Hi @prat1507,

You can create a RLS role filter below: 

Best Regards,
Qiuyun Yu