Cumulative measure with group by

[edersonsousa]

Hi dears,

I'm trying solve a problem with a measure I create to generate a total register by user and month/year and create a burndow graph.

So, in month like june 2022, when I don't have any register of my users, the cumulative measeure return a 0 values instead return the last value.
Below I sent the measure:

_TotalParcialReunioes =

   COUNTROWS( FILTER(

            GROUPBY(

                CALCULATETABLE(

                'DadosReuniões',

                FILTER(ALLSELECTED('DadosReuniões'),'DadosReuniões'[MesAno] <= MAX('DadosReuniões'[MesAno]) && 'DadosReuniões'[Encontro realizado] = TRUE())),

                'DadosReuniões'[Nome Funcionário],

                "QTDE_REUNIOES",

                COUNTX(CURRENTGROUP(),'DadosReuniões'[Nome Funcionário])

            ),

            [QTDE_REUNIOES] >=1

    ))+0

How can I reapeat the last value, when the month no has any data?

Thanks

[amitchandak]

@edersonsousa , We usually user these type of formula

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(all('Date'),'Date'[date] <=max('Date'[date])))

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected('Date'),'Date'[date] <=max('Date'[date])))

And on axis we use date/period from date table

[edersonsousa]

OK. But in my case I need to group by user and check if user has 1 or more lines... in this case I can´t use sum