Forum Discussion

nielfxrm's avatar
nielfxrm
Frequent Visitor
8 years ago
Solved

Cumulative sum with multiple filters

Hi,   I have created a running total DAX formula as below:   RunningTotal = CALCULATE( SUM( Opportunity[Sales Price (DKK)] ); FILTER( ALLSELECTED( Opportunity ); Oppor...
Need Help
  • PattemManohar's avatar
    PattemManohar
    8 years ago

    nielfxrm Please try changing the SUM function inside the CALCULATE as below:

     

    SUMX(FILTER(Opportunity,  Opportunity[Pipeline Category] = "Won"), Opportunity[Sales Price (DKK)])
Ashukak's avatar
Ashukak
New Member
2 years ago

I tried to following  this  method but get an error

 

 

T1B Cumulative Total =
CALCULATE (
    SUMX(FILTER('VO Register (2)','VO Register (2)'[04 Goal]="Improve Downside (45Q)"),Timeline[T1.Mid Cu.EPV(m$)]);
           FILTER(
            ALLSELECTED('Timeline'[D. Progress to Implement Gate 3]),
            'Timeline'[D. Progress to Implement Gate 3]<= max(Timeline[D. Progress to Implement Gate 3]
        ))
 

If i remove the " ;" then it tells me the Fileter argument is incorrect