Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Running total

Hello all,   I've this running total measure:   Running Total Ferien Rest = CALCULATE( SUM(DIA_SAP_ABSENZEN[Ferien Rest]), FILTER( ALLSELECTED(DIA_SAP_ABSENZEN), DIA_SAP_ABSENZEN[Datum] <= ...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Anonymous 

    I see that you're using the Date table fields for slicing. That's much better. Try this:

    Measure V4 = 
VAR max_ =
    MAX ( 'Date'[Date] )
RETURN
    CALCULATE ( SUM ( Table1[Ferien Rest] ), 'Date'[Date] <= max_, ALL ( 'Date' ) )

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak 

 

Thanks for your response.

 

Unfortunately it didn't work. 

 

- When I don't use any slicer filters at all, then it gives me a number slightly lower than what it should be, and it doesn't seem to correspond to any totals I can glean from my data:

 

 

- When I apply a filter for 2020, then I get a smaller figure than what it should be, and it still doesn't correspond to my totals:

 

- When I filter on a colleague name, then I get a huge number, unrelated to anything I have:

 

Could you please look into it?