GEOMEANX DAX Function (Statistical)

Syntax  |  Return values  |  Examples  |  Related  

Returns geometric mean of an expression values in a table.

Syntax

GEOMEANX ( <Table>, <Expression> )

Parameter	Attributes	Description
Table Iterator		Table over which the Expression will be evaluated.
Expression Row Context		Expression to evaluate for each row of the table.

Return values

Scalar A single decimal value.

Return a decimal number with the geometric mean.

» 1 related function

Examples

--  GEOMEANX is an iterator that computes the geometric mean of an expression
EVALUATE
{
     ( "Average",        AVERAGEX ( Sales, Sales[Quantity] * Sales[Net Price] ) ),
     ( "Geometric Mean", GEOMEANX ( Sales, Sales[Quantity] * Sales[Net Price] ) )
}

Value1	Value2
Average	305.21
Geometric Mean	89.14

Related functions

Other related functions are:

• GEOMEAN

Last update: Nov 14, 2024   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Daniel Otykier

Microsoft documentation: https://docs.microsoft.com/en-us/dax/geomeanx-function-dax