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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

You may refer to my solution here.

 

Hope this helps.

 

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

Ashish_Mathur 

lol thanks for the effort mate. I found a solution this morning after some testing and researching. 

 

Special Mention to Ashish_Mathur

Who offered alternate solution which is pretty sweet.

 

IF(ISBLANK([Forecasts]),BLANK(),CALCULATE([Forecasts],DATESYTD('Calendar'[Date],"30/6")))
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    You are welcome.