topic Re: Cumulative measure with group by in DAX Commands and Tips

Cumulative measure with group by

Anonymous — Fri, 09 Sep 2022 15:12:35 GMT

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

Re: Cumulative measure with group by

amitchandak — Fri, 09 Sep 2022 15:54:03 GMT

Anonymous , 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

Re: Cumulative measure with group by

Anonymous — Fri, 09 Sep 2022 18:36:35 GMT

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