Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Cumulative sum for a summarize variable in DAX

Hello,    I have a problem    in my original table i had a measure that cumulates value in time and where filters works, it's :  CALCULATE( SUM(table[Value]), ALL(Date table), FILTER(ALLSEL...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

Try the following expression:

Cumulative Value = 
VAR CurrentDate = MAX('Date Table'[Date])
VAR FilteredTable = FILTER(
    ALL('Date Table'),
    'Date Table'[Date] <= CurrentDate
)
RETURN
SUMX(
    FILTER(
        _t1,
        [Date] IN VALUES(FilteredTable[Date])
    ),
    [Value]
)

 

Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello

 

It don't work on the step : VALUES(FilteredTable[Date]) because he don't want to recognize FilteredTable ...

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

     

    Not quite sure what you mean, what is the error message it reports?

     

    Best regards,
    Community Support Team_ Scott Chang