Static RLS rules in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the DAX expression to create a static RLS filter for the 'Region' column.

Power BI

FILTER('Sales', 'Sales'[Region] = [1])

Drag options to blanks, or click blank then click option'

A"North"

BNorth

CRegion

D'North'

Attempts:

3 left

💡 Hint

Common Mistakes

Forgetting to use quotes around text values.

Using single quotes which are for table or column names.

In DAX, text values must be enclosed in double quotes inside expressions. So "North" is correct.

2fill in blank

medium

Complete the DAX expression to apply a static RLS rule filtering 'Country' to 'USA'.

Power BI

FILTER('Customers', 'Customers'[Country] = [1])

Drag options to blanks, or click blank then click option'

A'USA'

B"USA"

CUSA

D[USA]

Attempts:

3 left

💡 Hint

Common Mistakes

Using single quotes instead of double quotes for text.

Not quoting the text value at all.

Text values in DAX must be enclosed in double quotes inside expressions, so "USA" is correct.

3fill in blank

hard

Fix the error in this static RLS DAX filter expression by completing the blank.

Power BI

FILTER('Orders', 'Orders'[Status] = [1])

Drag options to blanks, or click blank then click option'

A"Completed"

BCompleted

C'Completed'

D[Completed]

Attempts:

3 left

💡 Hint

Common Mistakes

Using unquoted text which causes syntax errors.

Using single quotes which are invalid for text in DAX.

The text value must be enclosed in double quotes in DAX expressions, so "Completed" is correct.

4fill in blank

hard

Fill both blanks to create a static RLS rule filtering 'Category' to 'Electronics' in the 'Products' table.

Power BI

FILTER([1], [1][[2]] = "Electronics")

Drag options to blanks, or click blank then click option'

A'Products'

B'Product'

C'Category'

D'Categories'

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong table or column names.

Forgetting to quote table name or incorrectly quoting column name.

The table name is 'Products' and the column to filter is 'Category'. The table name must be in single quotes in DAX, but column names inside brackets are not quoted.

5fill in blank

hard

Fill all three blanks to create a static RLS rule filtering 'Region' to 'West' in the 'Sales' table using DAX.

Power BI

FILTER([1], [2][[3]] = "West")

Drag options to blanks, or click blank then click option'

A'Sales'

BSales

CRegion

D'Region'

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the table name.

Quoting the column name incorrectly.

Using wrong order of table and column.

The table name is 'Sales' (single quoted) for BLANK_1 and BLANK_2, the column is Region (no quotes inside brackets), and the filter value is "West".