Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
In the desktop version you can manage roles by defining a name, choosing the table and the "column"
Then you select one value out of this column to define a role
How can you manage a role which is assigned to more than one value out of one column?
Example:
There might be a role 1 allowed to see region North
There might be a role 2 allowed to see region South
There might be a role 3 allowed to see region North, South, ...
How can I modify the term (role1) below so that it fits to role 3, which is allowed to see at least 10 regions out of 30 regions
[Region] = "North" ...???
Thank you
Solved! Go to Solution.
Hi @Tine,
As the filter to create a role is using DAX expression, so you should be able to use "||" operator to add more regions to your role. The expression below is for your reference.
[Region] = "North" || [Region] = "South" || [Region] = "Other Regions"
Regards
Updated answer in updated PBI versions:
[Region] in {"North","South"}
Hi @Tine,
As the filter to create a role is using DAX expression, so you should be able to use "||" operator to add more regions to your role. The expression below is for your reference.
[Region] = "North" || [Region] = "South" || [Region] = "Other Regions"
Regards
It works indeed!
Example of working code:
[Код региона] ="32"||
[Код региона] = "33"||
[Код региона] = "44"||
[Код региона] = "50"||
[Код региона] = "57"||
[Код региона] = "61"||
[Код региона] = "62"
i am Using below DAX
How to use it like
[ABC] LIKE "XYZ%"
Thank you - it works
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |