Returns the mean of an expression after computing it once for each row in a table; if the table has no rows, this DAX iterator gives BLANK.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains AVERAGEX 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.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- Iterator
A DAX function like SUMX that steps through a table one row at a time, evaluating an expression in row context, and then aggregates what it gets.
- BLANK
DAX uses BLANK to mean no value at all. It resembles NULL in SQL but behaves more like an empty cell in Excel, so adding 20 to it returns 20; the BLANK function creates one and ISBLANK detects it.
Related terms
- AVERAGE
A DAX function giving the mean of a single numeric column; blank cells are skipped while zeros are included. To average a calculation worked out for each row, AVERAGEX is used instead.