Forum Discussion

Tine's avatar
Tine
New Member
9 years ago
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...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

 

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 following
 
When i select Multiple countries from country slicer i should get only one selection in Currency
slicer i.e.
 
it should only show Group for multiple selections
 
if there i single selection then it should show both group local .