Average of distinct count

[Anonymous]

I need a measure to calculate the average (distinct count of) tickets per site code as per visual below. I tried averagex, averagea but with incorrect results. Any tips please @tamerj1 ?

[johnt75 · Accepted solution]

Avg tickets =
var summaryTable = ADDCOLUMNS( VALUES( 'Table'[SITE_CODE]), "@val", [Distinct total tickets])
return AVERAGEX( summaryTable, [@val])

[Anonymous]

@johnt75 thank you for the prompt response, results look much better. Appreciate your help.