COUNTA DAX Function (Aggregation)
Counts the number of values in a column.
Syntax
Parameter | Attributes | Description |
---|---|---|
ColumnName |
The column that contains the values to be counted. |
Return values
Returns the number of cells in a column that contain a non blank value.
Remarks
The only argument allowed to this function is a column.
When the function finds no rows that are non-blank, it returns a blank.
COUNT and COUNTA are identical in DAX for all the data types except Boolean. COUNTA can operate on a Boolean data type, whereas COUNT cannot do that.
The COUNTA function internally executes COUNTAX, without any performance difference.
The following COUNTA call:
COUNTA ( table[column] )
corresponds to the following COUNTAX call:
COUNTAX ( table, table[column] )
Related functions
Other related functions are:
Last update: Dec 7, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
MSDN documentation: https://docs.microsoft.com/en-us/dax/counta-function-dax