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])  

COUNT function
COUNTAX function
COUNTX function
Statistical functions