Calculate average for rows matching conditions

I have added a column “Average” to a table called “Scorecard” which is calculating the average of column “Gross” in a table called “Rounds” using formula: AVERAGE(Rounds[Gross])

This gives me the average for all rows in table “Rounds”

I am trying to modify this to only calculate the average where the column “Hole” in table “Rounds” is equal to column “Hole” in the current table “Scorecard”.

Any help greatly appreciated.

1 Like

Thanks Marc - have successfully combined with Average function to get desired result.

1 Like