topic calculate Filterd VAR table to cumulative value in DAX Commands and Tips

calculate Filterd VAR table to cumulative value

ohnothimagain — Mon, 05 Aug 2024 23:19:56 GMT

Hello everyone! I came back again,,,😣
I want to make a table filtered and summary values cumulative,but this doesn't work.How should I correct it?

Ftd_sum := VAR tbl = SELECTCOLUMNS( FILTER(ALL('TEST_'), 'TEST_'[STS] = "〇"), "@Trg", 'TEST_'[PN] ) VAR Dis = DISTINCT(tbl) // OK VAR Ftd = CALCULATETABLE( 'TEST_', 'TEST_'[PN] IN Dis, FILTER( ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date]) ), USERELATIONSHIP('Calendar'[Date], 'TEST_'[Calculated]) ) VAR Result = CALCULATE( SUM('TEST_'[Qty]), KEEPFILTERS(Ftd) ) RETURN Result

Table (I'm doing it on powerpivot)

want it to be

Thank you for reading,and continuous support!
Best Regards,

Re: calculate Filterd VAR table to cumulative value

DataNinja777 — Mon, 05 Aug 2024 21:35:08 GMT

Hi ohnothimagain ,

What about modifying it as shown below?

Best regards,

Re: calculate Filterd VAR table to cumulative value

ohnothimagain — Tue, 06 Aug 2024 07:31:33 GMT

Thank you for your reply!

I tried,but it returned non-cumulative values.do you have any ideas more?