Forum Discussion

kman42's avatar
kman42
Frequent Visitor
1 year ago
Solved

Running total on a filtered table

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 wh...
Need Help
  • FreemanZ's avatar
    FreemanZ
    1 year ago

    hi kman42 ,

     

    try like:

    Forecast Cumulative = 

    CALCULATE(

         sum('Forecast'[Revenue])-

    sum('Forecast'[Expense]),

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

    )

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
1 year ago

hi kman42 ,

 

try like:

Forecast Cumulative = 

CALCULATE(

     sum('Forecast'[Revenue])-

sum('Forecast'[Expense]),

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

)