Trying to filter a running total to only dates that have data

[SamKrygsheld]

I'm trying to display a month over month running total of production. I would like this to be able to be filtered by slicers and filters on the page, so calculating in the data source itself is not really an option. However, when I calculate the running total within PowerBI, it shows dates in the future, which is not what I'm looking for.

I don't seem to be able to attach images, but I've linked to before/after images as well as a PBIX file showing what I'm talking about. Thanks!

Image - before 

Image - desired 

PBIX 

[v-easonf-msft · Accepted solution]

Hi ,  @SamKrygsheld 

You can take a try to change your measure as below:

Widgets running total in Day = 
IF(CALCULATE(COUNTROWS('Sheet1'))>0,
CALCULATE(
    SUM('Sheet1'[Widgets]),
    FILTER(
        ALLSELECTED('Sheet1'[Date sold].[Day]),
        ISONORAFTER('Sheet1'[Date sold].[Day], MAX('Sheet1'[Date sold].[Day]), DESC)
    )),BLANK())

 Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SamKrygsheld]

Thank you so much, that worked perfectly!