Back to Roadmap
Level 2 — Working With Filters+75 XP
Lesson 4

4. The FILTER Function

Table iterator used for complex multi-condition filters.

The Concept

FILTER is a table function that iterates over a table and returns only rows where a condition is TRUE.
Example DAX:
High Value Orders Revenue = 
CALCULATE(
    SUM(Sales[Revenue]),
    FILTER(Sales, Sales[Revenue] > 2000)
)

FILTER creates a row context over the table provided as its first parameter, testing each row against the boolean expression in the second parameter.

Try It Yourself

Use CALCULATE and FILTER to sum Sales[Revenue] where Quantity is greater than 3.

fx
[fx]The FILTER Function=
Loading DAX Formula Studio...
Type [ for fields