New Measure to calculate Average and count Zero/Null values

[audi357]

New User****
Trying to caluclate Avearage across years by row.

Count of charge average per Year =
AVERAGEX(
KEEPFILTERS(VALUES('Calendar'[Year],)),
CALCULATE(COUNTA('armain'[charge])
))

This Quick measure works but Does not account for years where no value was calculated.    Hence, Aggravated Battery  was 1 for 2016, and 1for 2017.  average should be 0.5.

Please help

[v-yulgu-msft · Accepted solution]

Hi @audi357,

Count of charge average per Year =
COUNTA ( 'armain'[charge] ) / DISTINCTCOUNT ( 'Calendar'[Year] )

Best regards,

Yuliana Gu