Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
Yes, It is possible.
You can use multiple conditions. Also, you can write DAX expressions using multiple variables and implement some tricky logic.
Proud to be a Super User!
Thanks, @nandukrishnavs. I understand that it can be implemented on a single table. But, how can I implement it for two different tables?
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |