Forum Discussion

Aree's avatar
Aree
Icon for Resolver I rankResolver I
8 years ago
Solved

Cumulative with a slicer

I working on doing a cumulative line which is basic using the standard appraoch. Forecast Cumulative = CALCULATE( SUM('Financial'[Forecast]), FILTER( ALL('Calenda...
Need Help
  • Aree's avatar
    Aree
    8 years ago

    Found my solution after some research and testing.

     

    Forecast Cumulative = 
 CALCULATE(
      SUM('Financial'[Forecast]), 
           FILTER(
                ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date])  )
                       )

    ALL was causing a filter context outside of my slicer but ALLSELECTED worked like a charm.

Aree's avatar
Aree
Icon for Resolver I rankResolver I
8 years ago

Found my solution after some research and testing.

 

Forecast Cumulative = 
 CALCULATE(
      SUM('Financial'[Forecast]), 
           FILTER(
                ALLSELECTED('Calendar'), 'Calendar'[Date] <= MAX('Calendar'[Date])  )
                       )

ALL was causing a filter context outside of my slicer but ALLSELECTED worked like a charm.