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

Anonymous's avatar
Anonymous
Not applicable
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