Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
GEOMEANX(<table>, <expression>)
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. |
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.
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
The following computes the geometric mean of the ReturnPct column in the Investments table:
= GEOMEANX( Investments, Investments[ReturnPct] + 1 )
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest Fabric, Power BI, and SQL learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today