Forum Discussion

Sparkeltje's avatar
Sparkeltje
Frequent Visitor
5 years ago
Solved

Running total with IF statement?

Hi guys,   Struggeling with a running total. I only want a running total if slicer selection is the same as a column in my table.    For example:  Slicer = FISCALYEAR   Then I only want a runn...
  • Sparkeltje's avatar
    Sparkeltje
    5 years ago
    Thank you for your reply, the following DAX solved my problem. 
     
    RT_DP_YEAR =

     

    VAR FISCALYEAR = SELECTEDVALUE('table'[FISCALYEAR])
     
    RETURN
    CALCULATE(SUMX('table',
     'table'[AMOUNT]),
     
    FISCALYEAR = 'table'[DP_YEAR],
    ALL('table'[FISCALYEAR]))
lbendlin's avatar
lbendlin
Super User
5 years ago

Running total needs something that it can sort by.  it is not clear from your data which column is suitable for sorting. Please elaborate.

Sparkeltje's avatar
Sparkeltje
Frequent Visitor
5 years ago
Thank you for your reply, the following DAX solved my problem. 
 
RT_DP_YEAR =

 

VAR FISCALYEAR = SELECTEDVALUE('table'[FISCALYEAR])
 
RETURN
CALCULATE(SUMX('table',
 'table'[AMOUNT]),
 
FISCALYEAR = 'table'[DP_YEAR],
ALL('table'[FISCALYEAR]))