Table of contents
Collapse the table of content
Expand the table of content


Owen Duncan|Last Updated: 10/5/2018
1 Contributor

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 (DAX).


GEOMEANX(<table>, <expression>)  


tableThe table containing the rows for which the expression will be evaluated.
expressionThe expression to be evaluated for each row of the table.

Return Value

A decimal number.


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.


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

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

See Also

GEOMEAN Function (DAX)

© 2018 Microsoft