GEOMEAN
The geometric mean of a column's numbers.
Group: Statistics. Compatible with DAX.
Syntax
GEOMEAN ( <column> )| Parameter | Type | Description |
|---|---|---|
column | Column | A column of numbers. |
Returns
Number. The n-th root of the product of the column's n values, blanks left out.
Remarks
- It is the right mean for growth factors and ratios, which multiply rather than add; for an expression, such as 1 + a return, use
GEOMEANX. - A zero among the values makes it 0.
- Negative values are taken as an odd root takes them: −1, 2.5 and 3.5 give about −2.06. With an even number of values whose product is negative, the result is NaN.
- Dates, text and TRUE/FALSE are errors. With no value the result is BLANK.
Examples
Geometric and arithmetic mean of four prices
EVALUATE
ROW (
"GEOMEAN", GEOMEAN ( Products[Price per liter] ),
"AVERAGE", AVERAGE ( Products[Price per liter] )
)| GEOMEAN | AVERAGE |
|---|---|
| 44.1338731313291 | 46 |
One zero makes it zero
The depot takes no crates, so over all places the geometric mean is 0; over the shops it is not.
EVALUATE
ROW (
"All places", GEOMEAN ( Places[Crates] ),
"Shops", CALCULATE ( GEOMEAN ( Places[Crates] ), Places[Kind] = "Shop" )
)| All places | Shops |
|---|---|
| 0 | 11.478208064669 |