Iterates a table, computing an expression for each row, and counts only those rows whose result is a non-blank number, string or date. Logical results need COUNTAX instead.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains COUNTX in context, with comparison tables and the common traps.
Terms in this definition
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Logical
Independent of any implementation. Each logical design is made real through a physical counterpart.
- COUNTAX
A DAX iterator that evaluates an expression across a table's rows and counts how many results are not blank, logical values included.