COUNTA
Counts the number of rows in the specified column that contain non-blank values.
Syntax
COUNTA(<column>)
Parameters
Term | Definition |
---|---|
column | The column that contains the values to be counted. |
Return value
A whole number.
Remarks
When the function does not find any rows to count, the function returns a blank.
Unlike COUNT, COUNTA supports Boolean data type.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
The following example returns all rows in the Reseller
table that have any kind of value in the column that stores phone numbers.
= COUNTA(Reseller[Phone])
See also
COUNT function
COUNTAX function
COUNTX function
Statistical functions