COUNTAX DAX Function (Aggregation)
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.
Related functions
Other related functions are:
Last update: Dec 14, 2018 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
MSDN documentation: https://msdn.microsoft.com/en-us/query-bi/dax/countax-function-dax