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 

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try like

 

Running Total Ferien Rest =

var _max = maxx(allselected(DIA_SAP_ABSENZEN),DIA_SAP_ABSENZEN[Datum])

return
CALCULATE(
SUM(DIA_SAP_ABSENZEN[Ferien Rest]),
FILTER(
ALL(DIA_SAP_ABSENZEN),
DIA_SAP_ABSENZEN[Datum] <= MAX(DIA_SAP_ABSENZEN[Datum])

&& DIA_SAP_ABSENZEN[Datum] < _max
)
)