Geomean based on IF condition not working

[Malick]

Hi,

I am trying to use the Geomean formula with an if condition but it is not working. I need to calculate geomean of values where my if condition is TRUE. Can you please help me fix the code. The current code is fetching GEOMEAN for the entire column of my table, ignoring the IF condition. I only need geomean of 'Final Score' values where my city is matched. Thanks.

=IF(Table1[@[city]]=[@City], GEOMEAN(TableaCalculation[Final Score]),0)

 

[Malick]

It works this time sir. I don't know what I was doing wrong previously but I copy pasted your formula without the curly braces and entered it as an array and it works. Sorry for the confusion and thanks a million for solving this issue Merci bien