COUNTAX DAX Function (Aggregation)

Syntax  |  Return values  |  Remarks  |  Related  

Counts the number of values which result from evaluating an expression for each row of a table.

Syntax

COUNTAX ( <Table>, <Expression> )

Parameter	Attributes	Description
Table Iterator		The table containing the rows for which the expression will be evaluated.
Expression Row Context		The expression to be evaluated for each row of the table.

Return values

Scalar A single integer value.

Returns the number of values that are non blank by iterating the provided table.

Remarks

When the function finds no rows producing a non-blank value, it returns a blank.

COUNTX and COUNTAX are identical in DAX for all the data types except Boolean. COUNTAX can operate on a Boolean data type, whereas COUNTX cannot do that.

Related functions

Other related functions are:

• COUNTX

Last update: Jan 11, 2021   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

MSDN documentation: https://docs.microsoft.com/en-us/dax/countax-function-dax