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 AlB 

 

Thank you for the new measure!

 

It works as far as filtering by colleague-name is concerned:

 

 

However, the moment I start filtering using the dates slicers.

 

The year filter for 2020 brings 0, when it should be 50.30:

 

 

And, when I add Q4 to the filter, it's -58.80, when it should be 50.30:

 

 

Can you please help with fixing the measure?

 

I've now updated the .pbix file on the Drive: https://drive.google.com/file/d/1I0mTOcldE0oLSKKFI_iyvYgUMKjPmtKG/view?usp=sharing

 

I look forward to hearing back from you.

 

Cheers.