Power Fx function
CountA — Power Fx function reference
Count non-blank values in a column.
Syntax
powerfx
CountA( Column )
Examples
powerfx
CountA(Orders.Notes)
→ A number
powerfx
CountA(Orders.Notes)
powerfx
CountA(Filter(Tasks, Status = "Done").CompletedBy)
Common mistakes & gotchas
- CountA counts any non-blank value regardless of type (text, number, date, boolean) — use it instead of Count when the column is not strictly numeric.
- Like Count, it operates on a single column, not a whole table; use CountRows for row counts.
Related Power Fx functions
From Math & aggregation