Power Fx function

Filter — Power Fx function reference

Return rows matching a condition.

Syntax

powerfx

Filter( Table, Condition1 [, Condition2, … ] )

powerfx

Filter(Staff, Department = "IT")

→ Matching rows

Multiple conditions are combined with an implicit AND.

powerfx

Filter(Orders, Status = "Open", Amount > 100)

→ Rows that are both Open and over 100

Use Or() inside a single condition when you need OR logic instead of AND.

powerfx

Filter(Staff, Or(Department = "IT", Department = "Ops"))

→ Rows in either department

Delegable against most sources when the column and operator are supported.
Filter always returns a table, even when you expect one row. Use First(Filter(...)) if you need a single record, or switch to LookUp — it reads clearer and stops after the first match.
A non-delegable predicate (calling a function the connector cannot translate, e.g. some text functions on SharePoint) caps the search at the row limit. Watch for the blue delegation warning triangle in Studio.

From Filtering, search & sort