Manage Roles - DAX version of NOT IN

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

Many thanks for your help - that works

[Anonymous]

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

[johnt75 · Accepted solution]

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