Running total on a filtered table

[kman42]

I have a table with revenues and expenses that is filtered by a slicer using Forecast ID. I'm trying to get a running total (Forecast Cumulative), but I can't seem to get the measure right. Here's what my table looks like. Forecast Cumulative is the measure:

The measure is: 

Forecast Cumulative = calculate(sum('Forecast Date Revenue Expense'[Revenue])-sum('Forecast Date Revenue Expense'[Expense]))

As you can see, it is just subtracting the expense from the revenue for each row. I need it to generate a running total so Forecast Cumulative should be:

15195

20204

11679

4530

etc

I'm sure I have the filters wrong, but not sure how to fix it.

Thanks!

[FreemanZ · Accepted solution]

hi @kman42 ,

try like:

Forecast Cumulative = 

CALCULATE(

     sum('Forecast'[Revenue])-

sum('Forecast'[Expense]),

    Forecast[date]<=MAX(Forecast[date])

)