FILTER function in Power BI - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to filter the Sales table for sales greater than 1000.

Power BI

FILTER(Sales, Sales[Amount] [1] 1000)

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

A<

B>

C=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' will filter for sales less than 1000.

Using '=' will filter only sales exactly equal to 1000.

The FILTER function requires a condition. To get sales greater than 1000, use the '>' operator.

2fill in blank

medium

Complete the code to filter the Customers table for customers in the 'USA'.

Power BI

FILTER(Customers, Customers[Country] [1] "USA")

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

A<

B>

C<>

D=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' will filter customers not in the USA.

Using '>' or '<' does not make sense for text comparison here.

To filter for customers in the USA, use the '=' operator to check equality.

3fill in blank

hard

Fix the error in the FILTER function to correctly filter products with stock less than 50.

Power BI

FILTER(Products, Products[Stock] [1] 50)

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

A<

B=

C>=

D>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '>' will filter products with stock greater than 50.

Using '=' will filter products with stock exactly 50.

To filter products with stock less than 50, use the '<' operator.

4fill in blank

hard

Fill both blanks to filter the Orders table for orders with quantity greater than 10 and status 'Completed'.

Power BI

FILTER(Orders, Orders[Quantity] [1] 10 && Orders[Status] [2] "Completed")

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

A>

B<

C=

D<>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for quantity.

Using '<>' instead of '=' for status.

The condition requires quantity greater than 10 and status equal to 'Completed'. Use '>' and '=' respectively.

5fill in blank

hard

Fill all three blanks to filter the Employees table for employees in 'Sales' department with salary greater than 50000 and active status.

Power BI

FILTER(Employees, Employees[Department] [1] "Sales" && Employees[Salary] [2] 50000 && Employees[Active] [3] TRUE())

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

A=

B>

D<>

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<>' instead of '=' for department or active status.

Using '<' instead of '>' for salary.

We check department equals 'Sales' (use '='), salary greater than 50000 (use '>'), and active status equals TRUE (use '=').