Forum Discussion

JohannesM's avatar
JohannesM
Icon for Helper I rankHelper I
4 years ago
Solved

Ackumulated sum with a measure

I have seen posts that explain how to do ackumulated sum from a table column but I need to show ackumulated sum in a table but with a measure as base. Is this possible? 

I have a measure that results in column B and now I want to create a measure that gives me column C if shown in a table like below.

Any ideas?

Thanks in advance!

  • Hi JohannesM 

    Please try

    Ackumulated =
    SUMX (
        FILTER ( ALLSELECTED ( 'Date'[Year] ), 'Date'[Year] <= MAX ( 'Date'[Year] ) ),
        [Measure]
    )

2 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    Hi JohannesM 

    Please try

    Ackumulated =
    SUMX (
        FILTER ( ALLSELECTED ( 'Date'[Year] ), 'Date'[Year] <= MAX ( 'Date'[Year] ) ),
        [Measure]
    )
    • JohannesM's avatar
      JohannesM
      Icon for Helper I rankHelper I

      Thanks!
      Solved within an hour, like always. Man I love this forum 😃