How does the COUNTA function (DAX) work?
The COUNTA function (DAX) counts the number of cells in a column that are not empty.
COUNTA Formula Syntax
How do you use the COUNTA function?
The COUNTA function counts cells containing any type of information, including error values and empty text (“”). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.
Related Blog Posts
Related Support Forum Posts
Considerations when using the COUNTA function
Be aware that COUNTA will also count cells that look empty, but actually contain invisible characters or an empty string (“”) returned by a formula. You can check which cells are blank using Go To > Special > Blanks:
- Select a range
- Open Go To dialog (Control + G)
- Press “Special”
- Select “Blanks”
Related Video Tutorials
Formula examples using the COUNTA function
Related DAX Functions
Related Course Modules
To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.