How to fill "itens with no data" with average Value?

[Anonymous]

I have the following scenario

The Price Column is the result of the following calculation

Price = DIVIDE(sum('Entrada Oferta'[Net value]),sum('Entrada Oferta'[Qt.Total OV]),BLANK())

 However, as you can see, there is some days where I didnt sell products (so this calculation will bring zero), for those days, I would like the Price assume the value of the average Price for the whole month. How can I solve it? 

Thanks in advance

[wdx223_Daniel · Accepted solution]

Price = DIVIDE(sum('Entrada Oferta'[Net value]),sum('Entrada Oferta'[Qt.Total OV]),VAR _y=values(dates[year]) VAR _m=values(dates[month]) RETURN CALCULATE(DIVIDE(sum('Entrada Oferta'[Net value]),sum('Entrada Oferta'[Qt.Total OV]),dates[year] IN _y,dates[month] IN _m,ALL(dates)))

[lbendlin]

Use COALESCE()