Create Roles with multiple condition with DAX

Question

Hello guys,Please I want to create a role on my data to implement LRS. Is it possible to add multiple conditions using the &amp;&amp; (AND) operator in DAX? if yes, how can I implement it?&nbsp;I have done something like this ==&gt; [UserId] = "Particular User Id" &amp;&amp; [DepartmentId] = "Department Id"&nbsp;&nbsp;

nandukrishnavs · Answer

DanielAd&nbsp;
&nbsp;
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 KrishnaDid I answer your question? Mark my post as a solution!Appreciate with a kudos 👍
Proud to be a Super User!

&nbsp;

nandukrishnavs · Answer

DanielAd&nbsp;
&nbsp;
You can select other tables and write filter conditions.
&nbsp;

danielad · Answer

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

Forum Discussion

Create Roles with multiple condition with DAX

3 Replies

Related content

Multiple conditions Index

Multiple Donut charts with conditions

Conditional Column with Multiple Conditions

Creating a measure with multiple conditions

Creating multiple Audiences in PowerBI App