COUNTAX

The COUNTAX function counts nonblank results when evaluating the result of an expression over a table. That is, it works just like the COUNTA function, but is used to iterate through the rows in a table and count rows where the specified expressions results in a non-blank result.

Syntax

COUNTAX(<table>,<expression>)  

Parameters

Term Definition
table The table containing the rows for which the expression will be evaluated.
expression The expression to be evaluated for each row of the table.

Return value

A whole number.

Remarks

Like the COUNTA function, the COUNTAX function counts cells containing any type of information, including other expressions.

For example, if the column contains an expression that evaluates to an empty string, the COUNTAX function treats that result as non-blank. Usually the COUNTAX function does not count empty cells but in this case the cell contains a formula, so it is counted.

Whenever the function finds no rows to aggregate, the function returns a blank.

Example

The following example counts the number of nonblank rows in the column, Phone, using the table that results from filtering the Reseller table on [Status] = Active.

=COUNTAX(FILTER('Reseller',[Status]="Active"),[Phone])  

See also

COUNT function (DAX)
COUNTA function (DAX)
COUNTX function (DAX)
Statistical functions (DAX)