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
Solved! Go to Solution.
[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"
Proud to be a Super User!
Hi,
You can also write as IN {"United States", "Canada"}
[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"
Proud to be a Super User!
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.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
136 | |
84 | |
65 | |
60 | |
55 |
User | Count |
---|---|
213 | |
108 | |
86 | |
82 | |
76 |