Missing values in cumulative count when filtering by month

[DidacBF]

Hi, I made this basic measure to cumulative SUM a value over the months:

PHs PLV Colocado Acumulado =

CALCULATE (

    DISTINCTCOUNTNOBLANK(PDV[ID pdv]),

    'Respuestas - PLV'[Colocado]=1,

    FILTER (

        ALL ( Calendario[Fecha visita] ),

        Calendario[Fecha visita] <= MAX ( ( Calendario[Fecha visita] ) )

    )

)
It is working when I use it on a matrix with months:

But when I filter by month, both items with no data that month disappear:

I think I'm missing something obvious but I can't make it work...

Thank you!!!

[DidacBF · Accepted solution]

Hello @Greg_Deckler !

Thank you for the reply but I might not explained myself.

With your solution it shows the categories but with a 0 as value, what i was expecting is the running total value even when the month has no data for that category:

This is what I want when I filter by month:

Thank you!!

I ended up making it work by creating a calculated table with summarizecolumns (month and category) and +0 for months with no data, and then a measure over it with MAX since the value will never decrease.
Not 100% happy because I'm pretty sure it's a better way of doing this but at least I got it working.

Thank you!!

[Greg_Deckler]

@DidacBF Try:

CALCULATE (
    DISTINCTCOUNTNOBLANK(PDV[ID pdv]),
    'Respuestas - PLV'[Colocado]=1,
    FILTER (
        ALL ( Calendario[Fecha visita] ),
        Calendario[Fecha visita] <= MAX ( ( Calendario[Fecha visita] ) )
    )
) + 0