Using IN operator in DAX for RLS

[alisoroush7]

hi guys,

i have a column named Persons that the usernames are inside it like below:

John,Dave,Ava,Chris

i want to use a RLS that get the username of entered user and only show data if the username include in that column.

i know that i can get the entered person username by USERNAME() but i dont know how to write the above expression in dax.

i have tried the below code in RLS but it gave me an error:

USERNAME() IN [Persons]

any comment is appreciated

[Samarth_18]

Hi @alisoroush7 ,

Have you tried below code:-

[Persons] = USERNAME()