The COUNTA function returns the number of cells in a column that are not blank. That is, it counts not only numeric values, texts, and dates like the COUNT function, but it also counts logical values.
Syntax
COUNTA(
column
)
Parameters
- column: Column whose values you want to count.
Returned value
The COUNTA function returns an integer.
Additional Information
If the function does not find any rows to count, it returns a blank. When there are rows, but none meet the expected requirements, the function returns 0.
Examples
In this example we are creating a measure that counts the number of customers with some data in the Customer[Phone] field:
Customers with phone number = COUNTA(Customer[Phone])
Category
Statistical