Forum Discussion
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...
[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"
Hi,
You can also write as IN {"United States", "Canada"}