topic Re: Create Roles with multiple condition with DAX in DAX Commands and Tips

Create Roles with multiple condition with DAX

DanielAd — Wed, 09 Dec 2020 12:44:12 GMT

Hello guys,

Please I want to create a role on my data to implement LRS. Is it possible to add multiple conditions using the && (AND) operator in DAX? if yes, how can I implement it?

I have done something like this ==> [UserId] = "Particular User Id" && [DepartmentId] = "Department Id"

Re: Create Roles with multiple condition with DAX

nandukrishnavs — Wed, 09 Dec 2020 15:00:55 GMT

DanielAd

Yes, It is possible.

You can use multiple conditions. Also, you can write DAX expressions using multiple variables and implement some tricky logic.

Regards,
Nandu Krishna

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍

Proud to be a Super User!

Re: Create Roles with multiple condition with DAX

DanielAd — Wed, 09 Dec 2020 15:36:35 GMT

Thanks, nandukrishnavs. I understand that it can be implemented on a single table. But, how can I implement it for two different tables?

Re: Create Roles with multiple condition with DAX

nandukrishnavs — Wed, 09 Dec 2020 16:49:14 GMT

DanielAd

You can select other tables and write filter conditions.