Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Running total based on time

I have the following table that I want to use as a running total for an area chart + a matrix visual:   Additionally, for my table the day doesnt end at 00:00, but after 03:00 am (see last li...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi Anonymous ,

     

    Are the date and item number column from the same table?

    Do you mean creating the slicer like this?

     

     

    If yes, you can try this measure.

     

    RT = 
VAR thistime =
    MIN ( 'Table'[Time] )
RETURN
    CALCULATE (
        SUM ( 'Table'[value] ),
        FILTER(
            ALLSELECTED ( 'Table' ),
        'Table'[Time] <= thistime
    ))

     

     

     

    If it doesn’t meet your requirement, could you please show the exact expected result based on the table that we have shared?

     

    Best regards,

     

    Community Support Team _ zhenbw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    BTW, pbix as attached.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Apologies, I should have been more clear. When creating the mockup file I noticed that the measure does indeed work. However, the measure does not take into account my slicers (date and item number right now), which I failed to mention in my opening post. Is there a way to adjust the measure so that slicers are always taken into account? Or how can I manually include this?