How does the COUNTA function (DAX) work?
The COUNTA function counts the number of cells in a column that are not empty. It counts not just numeric values, but also rows that contain nonblank values such as text, dates, and logical values.
COUNTA Formula Syntax
How do you use the COUNTA function?
The COUNTA function counts any type of information, and this includes error values and empty text. For example, if the range returns an empty string, the COUNTA function counts that value. What it does not count are empty cells.
Related Blog Posts
Related Support Forum Posts
Considerations when using the COUNTA function
The only argument for this function is a column. When the function finds no rows that are non-blank, it returns a blank. COUNT and COUNTA are identical for all the data types except Boolean. COUNTA can operate on a Boolean data type, while COUNT cannot do that.
Related Video Tutorials
Formula examples using the COUNTA function