COUNT DAX Function (Aggregation)
Counts the number of rows in the table where the specified column has a non-blank value.
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 COUNT function internally executes COUNTX, without any performance difference.
The following COUNT call:
COUNT ( table[column] )
corresponds to the following COUNTX call:
COUNTX ( table, table[column] )
Related functions
Other related functions are:
Last update: Jan 11, 2021 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
MSDN documentation: https://docs.microsoft.com/en-us/dax/count-function-dax