Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
60 | |
57 |