GEOMEANX DAX Function (Statistical)
Returns geometric mean of an expression values in a table.
Syntax
Parameter | Attributes | Description |
---|---|---|
Table Iterator |
Table over which the Expression will be evaluated. |
|
Expression Row Context |
Expression to evaluate for each row of the table. |
Return values
Return a decimal number with the geometric mean.
Examples
1 2 3 4 5 6 | -- GEOMEANX is an iterator that computes the geometric mean of an expression EVALUATE { ( "Average" , AVERAGEX ( Sales , Sales[Quantity] * Sales[Net Price] ) ) , ( "Geometric Mean" , GEOMEANX ( Sales , Sales[Quantity] * Sales[Net Price] ) ) } |
Value1 | Value2 |
---|---|
Average | 305.21 |
Geometric Mean | 89.14 |
Related functions
Other related functions are:
Last update: Mar 4, 2025 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Daniel Otykier
Microsoft documentation: https://docs.microsoft.com/en-us/dax/geomeanx-function-dax