Static RLS rules in Power BI - Cell-by-Cell Formula Trace

Sample Data

This data shows users and their assigned regions (A1:B5) and sales data by region (D1:E5). Static RLS rules will filter sales data by region based on user.

Cell	Value
A1	User
B1	Region
A2	Alice
B2	North
A3	Bob
B3	South
A4	Carol
B4	East
A5	Dave
B5	West
D1	Sales
E1	Region
D2	1000
E2	North
D3	1500
E3	South
D4	1200
E4	East
D5	1300
E5	West

Formula Trace

FILTER('Sales', 'Sales'[Region] = "North")

Step 1: 'Sales'[Region]

Step 2: 'Sales'[Region] = "North"

Step 3: FILTER('Sales', [TRUE, FALSE, FALSE, FALSE])

Cell Reference Map

  A       B       D       E  
1 User    Region  Sales   Region
2 Alice   North   1000    North  <-- Filter matches this row
3 Bob     South   1500    South
4 Carol   East    1200    East
5 Dave    West    1300    West

The filter uses the 'Sales'[Region] column (cells E2:E5) to compare with the static value 'North'.

Result

  D       E  
1 Sales   Region
2 1000    North

After applying the static RLS filter for region 'North', only the sales data for 'North' region remains visible.

Sheet Trace Quiz - 3 Questions

What does the FILTER function do in this static RLS rule?

A Keeps only rows where the region is 'North'.

B Keeps all rows regardless of region.

C Removes rows where region is 'North'.

D Changes the region name to 'North'.

Key Result

FILTER(table, table[column] = "fixed_value") filters rows where column equals a static value.