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 

     

AlB's avatar
AlB
Community Champion
5 years ago

Anonymous 

Perhaps I have misunderstood but this is very simple:

Measure V2 =
CALCULATE (
    SUM ( Table1[Ferien Soll] ),
    FILTER ( ALL ( Table1 ), Table1[Datum] <= MAX ( Table1[Datum] ) )
)

This will give you the cumulative value from the beginning of time up to the max date selected with the slicer. Do note that setting the slicers up like you have, quarter, month, week, etc all separately, you can have any kind of combination in the slicers. It is recommened to use a date table for the slicers instead of the date columns in the fact table. You have the date table already in the model; use it      

 

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