DAX - AVERAGEX() function in Power BI
AVERAGEX() -
Calculates the average (arithmetic mean) of a set of expressions evaluated over a table.
Syntax – AVERAGEX(table, expression)
Parameters –
table – Name of a table, or an expression that specifies the table over which the aggregation can be performed.
expression - An expression with a scalar result, which will be evaluated for each row of the table in the first argument.
Returns a decimal number.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
When there are no rows to aggregate, the function returns a blank.
You cannot include non-numeric or null cells.
Both the table and expression arguments are required.
All the key points of AVERAGE() function are being followed by the AVERAGEX() function.
Create a DAX specific table separate from the data table - • Create a specific table for your measures ...