Find average of blank or zero in matrix

[Tevon713]

I may have miss something see below example. Can't seem to find average of a measure if colum/row have zero. Ideally the closest was using this formula below, when selecting filter for region.   I tried summing up a column it didn't calculate correctly.

Average of Region_4 =

AVERAGEX(

 SUMMARIZE('Table','Table'[REGION],'Table'[SITE NAME]),[Visits per # of Office per Op Day]

)

Here's the data file: Data file 

[amitchandak · Accepted solution]

@Tevon713 , Try one of the 2

Average of Region_4 =
AVERAGEX(
SUMMARIZE('Table','Table'[REGION],'Table'[SITE NAME], "_1",if([Visits per # of Office per Op Day]=0 , blank(),[Visits per # of Office per Op Day]) ), [_1])


Average of Region_4 =
AVERAGEX(
SUMMARIZE('Table','Table'[REGION],'Table'[SITE NAME], "_1",[Visits per # of Office per Op Day]), [_1])