FILTER function in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the FILTER function do in Power BI?

FILTER returns a table that contains only the rows that meet a specified condition.

beginner

Write the syntax of the FILTER function.

FILTER(<table>, <condition>)<br><br>Where <table> is the table to filter and <condition> is the logical test applied to each row.

intermediate

Can FILTER be used inside a measure in Power BI?

Yes, FILTER is often used inside measures to create dynamic calculations based on filtered data.

beginner

What type of output does FILTER return?

FILTER returns a table, not a single value. This table can be used as input for other functions.

beginner

Example: How to filter the 'Sales' table to only include rows where 'Amount' is greater than 100?

FILTER(Sales, Sales[Amount] > 100)

What does the FILTER function return in Power BI?

A A filtered table

B A single number

C A text string

D A chart

FILTER returns a table containing only rows that meet the condition.

Which of these is the correct syntax for FILTER?

A FILTER(<table>)

B FILTER(<condition>, <table>)

C FILTER(<condition>)

D FILTER(<table>, <condition>)

FILTER requires a table first, then a condition to filter rows.

Can FILTER be used inside a measure to calculate values dynamically?

A Yes

B No

C Only in calculated columns

D Only in visuals

FILTER is commonly used inside measures for dynamic calculations.

If you want to filter rows where Sales[Quantity] is less than 50, which FILTER expression is correct?

A FILTER(Sales, Sales[Quantity] > 50)

B FILTER(Sales, Sales[Quantity] < 50)

C FILTER(Sales[Quantity] < 50)

D FILTER(<50, Sales)

The correct syntax is FILTER(table, condition).

What happens if FILTER condition matches no rows?

A Returns the whole table

B Returns an error

C Returns an empty table

D Returns zero

FILTER returns an empty table if no rows meet the condition.

Explain how the FILTER function works and give a simple example.

Think about how you pick only certain rows from a list based on a rule.

Describe a scenario where using FILTER inside a measure would be helpful.

Imagine you want to calculate totals but only for some specific data.