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

Thanks PattemManohar. That did the job. 

 

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

 

Cheers.