# GEOMEANDAX 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] ) )
}
```
Value1 Value2
Average 5.00
Geometric Mean 4.60

## Related functions

Other related functions are:

Last update: Aug 3, 2024     » Show contributors

Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber

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

# Context Transition

This function performs a Context Transition if called in a Row Context. Click to read more.

# Row Context

This expression is executed in a Row Context. Click to read more.

# Not recommended

The use of this function is not recommended. See Remarks and Related functions for alternatives.

# Not recommended

The use of this parameter is not recommended.

# Deprecated

This function is deprecated. Jump to the Alternatives section to see the function to use.

# Volatile

A volatile function may return a different result every time you call it, even if you provide the same arguments. Click to read more.

# Deprecated

This parameter is deprecated and its use is not recommended.

# DirectQuery compatibility

Limitations are placed on DAX expressions allowed in measures and calculated columns.
The state below shows the DirectQuery compatibility of the DAX function.

### Contribute

Want to improve the content of GEOMEAN? Did you find any issue?
Please, report it us! All submissions will be evaluated for possible updates of the content.