Forum Discussion
Manage Roles
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
Hi SohailAbdoola ,
Try to modify your formula like below:
[Business Unit] = "Motor Vehicles" && [Employee] IN {"1", "2", "3"}Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
lukiz84Memorable Member
Please show the data structure (tables used)
The table with Business Unit is connected to the Employee Table?
Hi SohailAbdoola ,
Try to modify your formula like below:
[Business Unit] = "Motor Vehicles" && [Employee] IN {"1", "2", "3"}Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly