Edit

Share via

COUNTA

  • Article

Applies to: Calculated column Calculated table Measure Visual calculation

Counts the number of rows in the specified column that contain non-blank values.

Syntax

DAX 
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 the number of all rows in the Reseller table that have any kind of value in the column that stores phone numbers.

DAX 
= COUNTA(Reseller[Phone])

Related content

COUNT function COUNTAX function COUNTX function Statistical functions