GEOMEAN DAX Function (Statistical)

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] ) )
}