show values from previous months in a specific month

[darko_ivanovic]

I am building a report for Defects(Bugs) in our Company. And everything worked out great untill i got to Driltrough. In the Drilltrough page i wanna showcase the how many defects were created, how many were closed and how many open defects there were in that month. 

The problem is, the open defect count is a running count, so when i drilltrough in august for example (August Values:    New: 139/ Closed: 114/ Open: 977) 

I see this:

In the top right corner it shows the right values, but in the table underneath are just 282 records. So i cannot see ALL open defects, just those which had either a creation-, resolved- or statuschange-date in August. I think this is because of "keep all filters" when i drilltrough august 2019 its sets the drilltrough filter to ("Month-Year" is Aug 2019) can I somehow disable that just for the Open defects ? Or is there a workaround this ?

The Goal is when drilled trough august, to see all created and closed defects IN AUGUST. And all open defects IN AND BEFORE august. 

[v-chuncz-msft]

@darko_ivanovic 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Use-a-date-slicer-to-filter-on-a-period-instead-of-a-single...

[darko_ivanovic]

@v-chuncz-msft 

I tried it out but cant figure out how to make that work with my datamodel.. 

Seems I need a diffrent solution