COUNTA

The COUNTA function counts the number of cells in a column that are not empty.

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.

Example

The following example returns all rows in the Reseller table that have any kind of value in the column that stores phone numbers. Because the table name does not contain any spaces, the quotation marks are optional.

=COUNTA('Reseller'[Phone])  

See also

COUNT function (DAX)
COUNTAX function (DAX)
COUNTX function (DAX)
Statistical functions (DAX)