Calculate the cumulative turnover

[Anonymous]

Hello,
I tried these two formulas to calculate the cumulative turnover but it did not work. Can you calculate the cumulated?
Here is a screenshot:

Thank you a lot

[v-frfei-msft]

Hi @Anonymous ,

Please try to use this one.

Cumuletest = Calculate(SUM(VN[Livaision]),FILTER(ALL(VN),[DateDeFacture]<=MAX([DateDeFacture])))

[Anonymous]

Hello @v-frfei-msft 
In my case delivery is already a measure, we can not put SUM before measure, ie we can not do the sum of a measure! ??

Thank you.
Cordially.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

To make a measure sum up, we can use SUMX such as.

 = SUMX(your table, [measure])

So in your scenario, we can update the formula like this to have a try,

Cumuletest =
CALCULATE (
    SUMX ( VN, [Livaision] ),
    FILTER ( ALL ( VN ), [DateDeFacture] <= MAX ( [DateDeFacture] ) )
)