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