Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
74 | |
56 | |
37 | |
33 |
User | Count |
---|---|
71 | |
65 | |
58 | |
50 | |
47 |