Power Fx function
Count — Power Fx function reference
Count numeric values in a column.
Syntax
powerfx
Count( Column )
Examples
powerfx
Count(Orders.Amount)
→ A number
powerfx
Count(Orders.Amount)
powerfx
Count(Filter(Orders, Status = "Paid").Amount)
Common mistakes & gotchas
- Count only counts numeric values in the column — text and non-numeric blanks are excluded; use CountRows for a general row count instead.
- It takes a single column reference (Table.Column), not a whole table — passing a table directly is a type mismatch.
Related Power Fx functions
From Math & aggregation