Edit

GEOMEANX

  • Article

Applies to: Calculated column Calculated table Measure Visual calculation

Returns the geometric mean of an expression evaluated for each row in a table.

To return the geometric mean of the numbers in a column, use GEOMEAN function.

Syntax

GEOMEANX(<table>, <expression>)

Parameters

Term Definition
table The table containing the rows for which the expression will be evaluated.
expression The expression to be evaluated for each row of the table.

Return value

A decimal number.

Remarks

  • The GEOMEANX function takes as its first argument a table, or an expression that returns a table. The second argument is a column that contains the numbers for which you want to compute the geometric mean, or an expression that evaluates to a column.

  • Only the numbers in the column are counted. Blanks, logical values, and text are ignored.

  • This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Example

The following computes the geometric mean of the ReturnPct column in the Investments table:

= GEOMEANX( Investments, Investments[ReturnPct] + 1 )

Related content

GEOMEAN function