New Measure

[mokhan]

Hello All,

I have a month column and another column with values. In order to show empty months in the report, I creates months without value as zero value. Now I want to calculate yearly average of the months excluding zero? How can I do it?

Thankyou for your help!

[amitchandak]

@mokhan , Try a measure like

divide([measure], calculate(distinctcount(Table[month]), filter(values(Table[Month]), [measure]<>0)))