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.




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.

Reference Data

DAX Functions / Statistical Functions / COUNTAX