Average calculation needed

Hi keen ,

I made simple samples and you can check the results below:

AVG = var _t = ADDCOLUMNS('Table',"count",COUNTX(FILTER(ALL('Table'),[year]=EARLIER([year])&&[Total]<>BLANK()),[Month]))
return AVERAGEX(_t,[Total]/[count])

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.