Forum Discussion
Solved
How to manage roles which are defined by multiple values
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 w...
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.:smileyhappy:
[Region] = "North" || [Region] = "South" || [Region] = "Other Regions"
Regards
v-ljerr-msft
Microsoft Employee
Microsoft EmployeeHi 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.:smileyhappy:
[Region] = "North" || [Region] = "South" || [Region] = "Other Regions"
Regards
Thank you - it works
The same case can work via AND condition.?How to use it like
[ABC] LIKE "XYZ%"
i am Using below DAX
Curreny Selected =IF(CALCULATE(COUNTROWS ( FILTERS ( Company[Country]) ),ALLSELECTED (Company[Country])) >1 ,"Group", IF(HASONEVALUE(Company[Country]) && SELECTEDVALUE('Currency'[Currency],"Please Select Currency AS Needed")="Local","Local","Group"))I want Result as followingWhen i select Multiple countries from country slicer i should get only one selection in Currencyslicer i.e.it should only show Group for multiple selectionsif there i single selection then it should show both group local .It works indeed!
Example of working code:
[Код региона] ="32"||
[Код региона] = "33"||
[Код региона] = "44"||
[Код региона] = "50"||
[Код региона] = "57"||
[Код региона] = "61"||
[Код региона] = "62"
