topic Re: Manage Roles - DAX version of NOT IN in DAX Commands and Tips

Manage Roles - DAX version of NOT IN

Anonymous — Mon, 16 Jan 2023 15:11:18 GMT

Hello

I have a table CostReport_Layout and within there is a column bud2_line . I want to restrict users so they cant see the bud2_lines that relate to Salary information.

[bud2_line] <> {"Salaries"} but for multiple values none of the below work. How would you do this

[bud2_line] <> {"Salaries", "Social security, pension and medical"}

[bud2_line] not in {"Salaries", "Social security, pension and medical"}

[bud2_line] not {"Salaries", "Social security, pension and medical"}

Thanks

Paul

Re: Manage Roles - DAX version of NOT IN

johnt75 — Mon, 16 Jan 2023 15:21:36 GMT

not [bud2_line] in {"Salaries", "Social security, pension and medical"}

Re: Manage Roles - DAX version of NOT IN

Anonymous — Tue, 17 Jan 2023 02:23:58 GMT

Hi Anonymous ,

Please try below steps:
1. below is my test table

Table:

2. add a table visual with field

3. create a role with below dax formula

not( [bud2_line]) in {"Salaries", "Social security, pension and medical"}

3. view as new role

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Manage Roles - DAX version of NOT IN

Anonymous — Tue, 17 Jan 2023 13:54:58 GMT

Many thanks for your help - that works

Re: Manage Roles - DAX version of NOT IN

Anonymous — Wed, 18 Jan 2023 01:46:26 GMT

Hi Anonymous ,

Thanks for your feedback.

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

Best regards,
Community Support Team_Binbin Yu