Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
User | Count |
---|---|
84 | |
76 | |
74 | |
48 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |