Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 months ago
Solved

DAX Help cumulative calculation

Hello - I am trying to calculate cumulative calculation, X axis = Description, Y Axis = Amount$M, Line y-axis = Cumulative % its working fine if i select single Quarter in the Filter (callendar tabl...
Need Help
  • vojtechsima's avatar
    vojtechsima
    10 months ago

    hey, Anonymous 
    SELECTEDVALUE will return blank if there is more than value in current context. So you can only select single qurater if you wanna do it this way.

    If I were you, I would build the cumulative sum differently:

     



    cumulative = 
CALCULATE(
    [Amount $M],
    'fact'[Quarter] <= MAX('fact'[Quarter])
)

     

vojtechsima's avatar
vojtechsima
Super User
10 months ago

hey, Anonymous 
SELECTEDVALUE will return blank if there is more than value in current context. So you can only select single qurater if you wanna do it this way.

If I were you, I would build the cumulative sum differently:

 



cumulative = 
CALCULATE(
    [Amount $M],
    'fact'[Quarter] <= MAX('fact'[Quarter])
)