System_CAPS_ICON_note.jpg Note

This function is included in SQL Server 2016 Analysis Services (SSAS), Power Pivot in Excel 2016, and Power BI Desktop. Information provided here is subject to change.

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.

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 )  

GEOMEAN Function (DAX)

Community Additions