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 ...
mokhan , Try a measure like
divide([measure], calculate(distinctcount(Table[month]), filter(values(Table[Month]), [measure]<>0)))