cumulative per category

[Anonymous]

Hi,

I would like to find a measure that returns cumulative totals of values per category.

I have found the formula for cumulative totals:

Cumulative total = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'[Date].[Date]),'Table'[Date].[Date]<=MAX('Table'[Date])))

Can I add something to this formula to be able to distinguish between categories?

Thank you in advance

[amitchandak · Accepted solution]

@zpf , Test as

Total acumulado: CALCULATE(SUM('Table'[Value]),FILTER(ALL('Table'),'Table'[Date]]<-MAX('Table'[Date]) && 'Table'[category]]<-MAX('Table'[category])))

O

Cumulative total: CALCULATE(SUM('Table'[Value]),ALL('Table'[Date]), ALL('Table'[category]),FILTER(('Table'),'Table'[Date]]<-MAX('Table'[Date]) && 'Table'[category]]<-MAX('Table'[category])))

[Anonymous]

Thank you, amitchandak! 🙂

[v-kelly-msft]

Hi @Anonymous ，

Is your issue solved now?

If so,could you pls mark the reply as answered  to close it?

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!