Moving average excluding days without data

[evadung]

Hello, 

I have this chart with moving average. I dont want to see 4th and 5th day because theres no data (theres more date without data, 4th and 5th is for example). I have no clue what to do.

Its from calculated measure from two tables:

Table1: date, hours1
Table2: date, hours2

(In those tables arent days with null or blank spaces.)

calculated measure: Produtivität = hours1/hours2

Moving average % =

averagex(

    FILTER(ALLSELECTED(Kalender),

    Kalender[Datum] <= MAX(Kalender[Datum])),

        [Produktivität])

[wdx223_Daniel · Accepted solution]

Moving average % =IF( [Produktivität],

averagex(

    FILTER(ALLSELECTED(Kalender),

    Kalender[Datum] <= MAX(Kalender[Datum])),

        [Produktivität]))

[evadung]

Works! Thank you!