Translate future 3 yrs Geomean formula (from excel) to calculated column (in Power BI)

[TWMY1014]

Hi Experts,

As per title, the excel formula for calculate (-5.85) from above 3 cells (-7.43, -4.69 -5.39) was below:

 =GEOMEAN(1+(AP36:AR36)/100)-1)*100

I've try to convert in calculated column in below but fail :

******

test =

var MinYear = '**DM-RealEstatePriceIndicator**'[Year]

var MaxYear = MinYear+2

var After3YrGeomean = CALCULATE(GEOMEAN('**DM-InvestabilityIndex**'[Value]), AND('**DM-RealEstatePriceIndicator**'[Year]>=MinYear,'**DM-RealEstatePriceIndicator**'[Year]<=MaxYear),ALLEXCEPT('**DM-RealEstatePriceIndicator**','**DM-RealEstatePriceIndicator**'[CITY],'**DM-RealEstatePriceIndicator**'[Type]))

return

After3YrGeomean
******
Part of the table image was below for your reference:

Thanks a lot.

[Greg_Deckler]

@TWMY1014 Maybe try:

test =
var MinYear = '**DM-RealEstatePriceIndicator**'[Year]
var MaxYear = MinYear+2
var Types = DISTINCT('**DM-RealEstatePriceIndicator**'[Type])
var Cities = DISTINCT('**DM-RealEstatePriceIndicator**'[CITY])
var Table = FILTER(ALL('**DM-RealEstatePriceIndicator**'), AND('**DM-RealEstatePriceIndicator**'[Year]>=MinYear,'**DM-RealEstatePriceIndicator**'[Year]<=MaxYear) && '**DM-RealEstatePriceIndicator**'[CITY] IN Cities && '**DM-RealEstatePriceIndicator**'[Type] IN Types)
return
GEOMEANX(__Table,[Value])

[TWMY1014]

Hi Greg, 

Thanks a lot for your prompt response. 

However, it still shows 0.