RLS - Application of Multiple Filters

[Anonymous]

Wonder if anyone can help. I have a model with 10 'grouping' of data. The Groups are by business are. I know how to create RLS groups so that a user can see just one business area or all business areas.

What is the filter expression in RLS that enables a user to see two business areas. I've tried the AND (&&) and OR (||) operators but these don't work. 

[TableName] = "123456" || [TableName] = "654321" is what Solved: RLS:table filter DAX expression- possible to give ... - Microsoft Power BI Community suggests but it does not work, so wondering if I'm doing something wrong or if the issue is elsewhere.

When I use a single filter expression RLS works.

Thanks

[amitchandak]

@Anonymous , it should be a column name ? in a given table in RLS role

[ColumnName] = "123456" || [ColumnName] = "654321

[Anonymous]

I was using ColumnName, however I applied the filter to two tables. One Table had the correct expression on the Column using the OR operator, the other table was using the AND Operator on the Column. Now both are using the OR operator and it work. Thanks