Scribd
Upload
10 views5 pages

DAX Average Functions Explained

The document compares the AVERAGE and AVERAGEX functions in DAX. AVERAGE calculates the average of a column, ignoring non-numeric values. AVERAGEX allows calculating averages based on expressions for each row before averaging, making it more flexible.

Uploaded by

Tforta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
10 views5 pages

DAX Average Functions Explained

The document compares the AVERAGE and AVERAGEX functions in DAX. AVERAGE calculates the average of a column, ignoring non-numeric values. AVERAGEX allows calculating averages based on expressions for each row before averaging, making it more flexible.

Uploaded by

Tforta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

DAX AGGREGATION

FUNCTIONS :
AVERAGE()
VS
AVERAGEX()

JASWANTHI MAMIDISETTY
1
AVERAGE()
Calculates the arithmetic mean of a
column. It considers only numeric
values and ignores non-numeric
values.

Syntax:

=AVERAGE(column_name)
2
AVERAGEX()
AVERAGEX is a more flexible
function that allows to calculate
averages based on expressions.

Syntax:
= AVERAGEX(table, expression)
AVERAGEX()
It evaluates the given expression for
each row, then calculates the
average of the results

It is particularly useful when you


want to perform a more complex
calculation on each row before
averaging.
DO YOU LIKE
THE POST ?

JASWANTHI MAMIDISETTY

You might also like