Using IN operator in DAX for RLS

alisoroush7 — Tue, 31 Jan 2023 07:02:33 GMT

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

Re: Using IN operator in DAX for RLS

Samarth_18 — Tue, 31 Jan 2023 07:22:01 GMT

Have you tried below code:-

[Persons] = USERNAME()