Average with Datesbetween

[Anonymous]

Hi,
I have some unexpected values that I dont understand why they appear.

I calculate a daily value using average called D_1 Auction as below:

I also calculated a monthly average using my Dates Table called Fechas, and related to the table "Mibgas PVB"). I call this measure 

As expected, with a monthly context, both measures are equal, but in the second one, the total average appears without any date.

 Why this value appears and how can I get rid off it?

Thanks

[Anonymous · Accepted solution]

Solved using this measure:

D_1 Auction Promedio = IF( [D_1 Auction]=BLANK(),BLANK(),

 CALCULATE(

    [D_1 Auction],

    DATESBETWEEN(Fechas[Dia],STARTOFMONTH(Fechas[Dia]),ENDOFMONTH(Fechas[Dia]))

)

)