Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi All
I am using the Manage Roles feature in Power BI Desktop and all is great until I needed to have multiple fields included from the table I'm working with. I bumped into a syntax error. I'm an extreme novice with Dax and would appreciate some help.
I have a role I'm trying to create which includes two territories. I thought I had it, however the app indicates the syntax is wrong. So for salesperson A...the role needs to be that they can see only data from territories PA and MID.
[Territory] = "PA";"MID"
Would anyone be able to tell me when I'm creating a role with the need for multiple criteria from one column/field...how would I modify this syntax to get it right?
Emma
Solved! Go to Solution.
[Territory] = "PA" || [Territory] = "MID"
| User | Count |
|---|---|
| 25 | |
| 22 | |
| 22 | |
| 19 | |
| 13 |
| User | Count |
|---|---|
| 68 | |
| 55 | |
| 44 | |
| 42 | |
| 30 |