Manage Roles

[SohailAbdoola]

Hi, 

I am trying to add filters to implement RLS. When in manage roles I have applied a filter from my table i.e., "Business Unit" e.g. [Business Unit] = "Motor Vehicles". I now require an additonal filter from the same table however within this filter I require 3 values .

Ideally I would require the DAX to look like this but the below does not work. 

[Business Unit] = "Motor Vehicles" && [Employee] = "1" || [Employee] = "2" || [Employee] = "3" 

Please help 

[Anonymous · Accepted solution]

Hi @SohailAbdoola ,

Try to modify your formula like below:

[Business Unit] = "Motor Vehicles"   && [Employee] IN {"1", "2", "3"}

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lukiz84]

Please show the data structure (tables used)

The table with Business Unit is connected to the Employee Table?