GEOMEAN DAX Function (Statistical)

Syntax  |  Return values  |  Remarks  |  Examples  |  Related  

Returns geometric mean of given column reference.

Syntax

GEOMEAN ( <ColumnName> )

Parameter	Attributes	Description
ColumnName		Column that contains values for geometric mean.

Return values

Scalar A single decimal value.

Return a decimal number with the geometric mean.

Remarks

The GEOMEAN function internally executes GEOMEANX, without any performance difference.
The following GEOMEAN call:

GEOMEAN ( table[column] )

corresponds to the following GEOMEANX call:

GEOMEANX (
    table,
    table[column]
)

» 1 related function

Examples

--  GEOMEAN computes the geometric mean of the values in a column.
--  GEOMEAN is the short version of GEOMEANX, when used with one 
--  column only.
DEFINE
    TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 }
EVALUATE
{
     ( "Average",        AVERAGE ( SampleData[Value] ) ),
     ( "Geometric Mean", GEOMEAN ( SampleData[Value] ) )
}

Value1	Value2
Average	5.00
Geometric Mean	4.60

Related functions

Other related functions are:

• GEOMEANX

Last update: May 18, 2022   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

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