Row Level Security Question

[brunozanoelo]

Hi guys!

Sorry, in not good with DAX, it's my first experience with it.

How can i filter one field using a 'IN' and a OR to another Fields on the Row level security(RLS) option?

For Example, in this case in SQL i can make this:
AND ((FIELD IN (1,2,3,4)) OR (FIELD2 IN (500,501,502)))

Many thanks!

[v-yulgu-msft · Accepted solution]

Hi @brunozanoelo,

It seems that the SQL query you provided is only a part of the logical expression. Suppose the entire expression is like:
[FILED3]="A" AND ((FIELD IN (1,2,3,4)) OR (FIELD2 IN (500,501,502))).

Then switch it from SQL to DAX:
OR(AND([FIELD3]="A",[FIELD] in( 1,2,3,4)), [FIELD2] in (500,501,502))

For more information about how to use logical function in DAX, please see: Logical Functions (DAX)

If you still have any question, please feel free to ask.

Best regards,
Yuliana Gu