GEOMEAN Function (DAX)

How does the GEOMEAN function (DAX) work?

GEOMEAN function returns the geometric mean of the numbers in a column.

GEOMEAN Formula Syntax

GEOMEAN (<column>)

How do you use the GEOMEAN function?

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

Related Blog Posts

create-a-table-in-power-bi
How-To-Harvest-Power-BI-Slicer-Selections-To-Use-Within-Other-Measures
Power-BI-WHAT-IF-Parameters

Related Support Forum Posts

Normal Distribution Curve
Less Commonly Used Advanced Table Functions
What-if analysis in Direct Query

Considerations when using the GEOMEAN function

GEOMEAN( Table[Column] ) is equivalent to GEOMEANX( Table, Table[Column] )

To return the geometric mean of an expression evaluated for each row in a table, use GEOMEANX function (DAX).

Related Video Tutorials

EDNA-TV-show-last-3-sales
creating-great-color-palettes-for-power-bi-data-visualization-tips

Formula examples using the GEOMEAN function

=GEOMEAN( Investment[Return] )

Related DAX Functions

GEOMEANX

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.