Forum Discussion
New Measure
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!
1 Reply
mokhan , Try a measure like
divide([measure], calculate(distinctcount(Table[month]), filter(values(Table[Month]), [measure]<>0)))
