Create Roles with multiple condition with DAX

[DanielAd]

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"

[nandukrishnavs]

@DanielAd 

Yes, It is possible.

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

[DanielAd]

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

[nandukrishnavs]

@DanielAd 

You can select other tables and write filter conditions.