Forum Discussion

nielfxrm's avatar
nielfxrm
Frequent Visitor
7 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
    7 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)])
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 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)])
  • nielfxrm's avatar
    nielfxrm
    Frequent Visitor
    7 years ago

    Thanks PattemManohar. That did the job. 

     

    I was trying to add the filter somewhere else in the formula.

     

    Cheers.