RLS with multiple roles in Power BI - Cell-by-Cell Formula Trace

Sample Data

This table shows users, their assigned roles, and their regions. Roles determine what data each user can see.

Cell	Value
A1	User
B1	Role
C1	Region
A2	Alice
B2	Sales
C2	North
A3	Bob
B3	Marketing
C3	South
A4	Carol
B4	Sales
C4	East
A5	Dave
B5	Finance
C5	West

Formula Trace

FILTER(Users, Users[Role] = "Sales" || Users[Role] = "Marketing")

Step 1: Users[Role] = "Sales"

Step 2: Users[Role] = "Marketing"

Step 3: Users[Role] = "Sales" || Users[Role] = "Marketing"

Step 4: FILTER(Users, condition)

Cell Reference Map

    A       B         C
1 | User  | Role    | Region
2 | Alice | Sales   | North
3 | Bob   | Marketing | South
4 | Carol | Sales   | East
5 | Dave  | Finance | West

Formula references column B (Role) to filter rows.

The formula uses the Role column (B) to check each user's role and filter the table accordingly.

Result

    A       B         C
2 | Alice | Sales   | North
3 | Bob   | Marketing | South
4 | Carol | Sales   | East

The filtered table shows only users with roles 'Sales' or 'Marketing'. Dave with 'Finance' role is excluded.

Sheet Trace Quiz - 3 Questions

Which users are included after applying the RLS filter?

A Bob, Dave

B Alice, Dave

C Alice, Bob, Carol

D Carol, Dave

Key Result

FILTER(table, condition1 || condition2) filters rows matching either condition.