Forum Discussion

vonckk's avatar
vonckk
Frequent Visitor
5 years ago
Solved

Creating Cumulative Measure referencing another meausre

Hello, I could really use some help with a visual I'm working on.  I'm looking to show the actual spend, forecasted spend, monthly delta, and the cumulative delta throughout the year.  The chart b...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi vonckk ,

     

    Try using SUMX() function.

    Measure = ABS(SUM('Table'[value1])-SUM('Table'[value2]))

Measure 2 = SUMX(FILTER(ALLSELECTED('Table'),'Table'[date]<=MAX('Table'[date])),[Measure])

     

    Best Regards,

    Jay

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago
can you provide the code you used for the cummulative total? What error did you get.
vonckk's avatar
vonckk
Frequent Visitor
5 years ago

 

Cumulative R&A Project Delta =
Calculate(
[R&A Absolute Delta],
Filter(
Allselected('Import - RA Financials'[R&A Period Date]),'Import - RA Financials'[R&A Period Date]<=max('Import - RA Financials'[R&A Period Date])))
 
This is actually not giving me an error, but is just duplicating the same line as in the original graph.  I'm not seeing any cumulation happening by date.

Thanks,
 
Kyle