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...
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 . 

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 .