Power BI help needed

I need a COUNT measure, which will keep a Test Script whenever the script State="Closed" and will remove the Test Script whenever the State="Decomissioned" OR Validated="Out of Scope". Then, I need it to only display all the changes ref to the lastest FirstStatusChangedDate (e.g.: latest TAG changes, lastest Title changes,etc). So basically, what I want is to have a measure which will remove the State entries when State="Decomissioned" OR Validated="Out of Scope" and keep State="Closed". e.g.: If Validated="Out of Scope", then remove this entry If State=Decommissioned, remove this entry If State=Closed and Validate=anything other than "Out of Scope", then keep and display the last updates (from FirstStatusChangedDate). However, I can't use simple visual filter as my date slicer should COUNT whenever the script was Closed and then stop counting it whenever it gets decommissioned or out of scope. It's dynamic, which is why I need a measure. So, if the script got Closed in Jan/20 and then got Decommissioned or Out of Scope in Mar/20, when the person selects the year 2020 in my slicer, it should count the script as Closed (in scope) for January, February and March (but only count once) and after March it should stop counting the script. Which means, the measure will count as 1 script (the same script) between Jan and Mar/20.