Forum Discussion

Lewa's avatar
Lewa
Helper I
8 years ago
Solved

Cumulative Sum with required filter

Hi all! 

 

I need your help again.

 

So, 

 

Measure = 
VAR FILTER2 = FILTER(ALL(Calendary) ; Calendary[Date] <= MAX(Calendary[Date])) // <--cumulative filter
VAR FILTER1 = FILTER(Transactions ; TRUE()) // <--required filter <just for sample>
VAR RES = CALCULATE ( CALCULATE(SUM(Transactions[Cost]) ; FILTER2 ) ; FILTER1 ) 
RETURN RES

Problem is: 

  • without required FILTER1 its work correct: 

 

 

  • with -- nope!

 

Need Help
  • Lewa's avatar
    Lewa
    8 years ago

    Solution is: 

     

    RETURN CALCULATE(CALCULATE(SUM(Transactions[Cost]) ; FILTER1 ) ; FILTER2 ) //FILTER1 = FILTER(Transactions ; TRUE() )
RETURN CALCULATE(CALCULATE(SUM(Transactions[Cost]) ; FILTER(Transactions ; TRUE() ) ) ; FILTER2 ) 

    -- not identical and return various dataset . 

1 Reply

  • Lewa's avatar
    Lewa
    Helper I
    8 years ago

    Solution is: 

     

    RETURN CALCULATE(CALCULATE(SUM(Transactions[Cost]) ; FILTER1 ) ; FILTER2 ) //FILTER1 = FILTER(Transactions ; TRUE() )
RETURN CALCULATE(CALCULATE(SUM(Transactions[Cost]) ; FILTER(Transactions ; TRUE() ) ) ; FILTER2 ) 

    -- not identical and return various dataset .