Forum Discussion

raasrini's avatar
raasrini
Frequent Visitor
9 years ago
Solved

RLS:table filter DAX expression- possible to give multi values

Hi ,

 

Is it possible to add multiple values to the Table Filter Dax expression in Mange Roles -RLS. eg: I would like to give [Country]="United States","Canada".  I tried add filter and Gave in the Format [Country]="United States" && [Country]="Canada" and that doesn't seem to work either though there is no error while validation, but when I try to use Test as Role, I see nothing.

 

Any help is highly appreciated.

 

Regards,

Raaju

  • Anonymous's avatar
    Anonymous
    9 years ago

    [Country]="United States" && [Country]="Canada" would translate as "[Country] must simultaneously have both the values 'United States' and 'Canada'" which is logically impossible for a single field to do. You need to use an OR operator, not AND. [Country]="United States" || [Country]="Canada"

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    [Country]="United States" && [Country]="Canada" would translate as "[Country] must simultaneously have both the values 'United States' and 'Canada'" which is logically impossible for a single field to do. You need to use an OR operator, not AND. [Country]="United States" || [Country]="Canada"

    • raasrini's avatar
      raasrini
      Frequent Visitor
      9 years ago

      Yes you are right. It works. Thanks a lot :) I tried the default add filter option and not sure what can be capable with this.