COUNTA DAX Function (Aggregation)
Counts the number of values in a column.
Syntax
COUNTA ( <ColumnName> )
| Parameter | Attributes | Description |
|---|---|---|
| ColumnName |
The column that contains the values to be counted. |
Return values
Scalar A single integer value.
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.
Related functions
Other related functions are:
Last update: Feb 6, 2019 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Daniil Maslyuk
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/counta-function-dax