Hi my friends!I would need help with geometric mean... I have a matrix with the number of students per year (2009/2017).In a plot I got the % variations YoY (Δ%),as following: I used the following calculation: Δ =VAR y =SELECTEDVALUE ( ISCRITTI[AA] )VAR prev =CALCULATE ( COUNT ( ISCRITTI[Student_ID] ); ISCRITTI[AA] = y - 1 )RETURNDIVIDE ( COUNT ( ISCRITTI[Student_ID] ); prev ) and then: Δ% = (ISCRITTI[Δ] * 100) - 100 Now, I would like to get a mesure wich provided the geometric mean of the variations (not %) YoY, that is the Δ values (not Δ%).May you help me????Thanks a lotAle

Hi again ecoaleThanks for the additional explanation. It sounds like you want to see the same constant geometric mean across all years.Try either of these measures: Geometric Mean of Δ = GEOMEANX ( ALLSELECTED ( ISCRITTI[AA] ), [Δ] ) or Geometric Mean of Δ = CALCULATE ( GEOMEANX ( VALUES ( ISCRITTI[AA] ), [Δ] ), ALLSELECTED () )My original measure would have worked as a standalone measure on a card, but not when filtered on an individual year. Regards,Owen

GEOMEAN???? :( | Microsoft Fabric Community

Forum Discussion

Related content

Geomean Help

Geomean with filter in a measure

Ayuda de Geomean

How to calculate geomean by yearly, monthly and daily

Calculating GEOMEAN on roll up and roll down basis based on several columns