Open Incidents per day

Dear All,

I'm having some trouble with creating a measure which check for the number of open incidents.
I want to place this measure in a matrix or chart with Date on the rows.

1. My thought process has been the following:
   I have a fact table called Raw_Transaction which contains status changes for incidents such as creating, updating, and closing. An IncidentId can appear multiple times in this table, and an incident ID can be opened and closed multiple times. So an incident ID will have multiple records. This table is ~15.000.000 rows. 
2. To make it a bit easier for myself (I think...), I've created a column which is a basically a RANK number of what number this transaction is for an incidentID, called "CountOfTransaction". E.g. incidentID = 1 and CountOftransaction = 6, that means it's the 6th status change/transaction for incidentID 1.
3. 
4. To get each incidents latest status for a date, my idea was to:
   Create vTable with CALCULATETABLE
   Filter this table using DATESINPERIOD to adjust the daterange when the measure is in a visual.
   Then Create a column with ADDCOLLUMS which checks for each incident ID's the highest "CountOftransaction" in the context that has been adjusted by DATESINPERIOD. 
   FILTER that in a ROW context to say that the CountOFtransaction needs to be equal the [@MaxTransaction]
   Count the IncidentID's where that result is not "Closed".
5. Currently I have the expression below (hope this illustrates what I want to accomplish) but it’s not working as I'd hoped. Would it be possible to comment on how to create the correct calculation? If you can comment on 'why'  it's not working that be appreciated as well! Thanks in advance for the assistance! 
   
   

Open Incidents = 

VAR MaxDate = MAX('_Date'[Date]) 

VAR MinDate = 
CALCULATE(
    MIN(
        '_Date'[Date]
    ),
    REMOVEFILTERS()
)

VAR NoOFDays = ABS(Maxdate) - ABS(MinDate)

VAR Period = 
DATESINPERIOD(
    _Date[Date],
    Maxdate,
    -NoOFDays,
    DAY
)

VAR _CalcTable =
CALCULATETABLE(
    Raw_Transactions,
    Period
)

VAR _vTable =
ADDCOLUMNS(
    _CalcTable,
    "@MaxTransaction", 
        VAR Result =
        CALCULATE( 
            MAX( Raw_Transactions[CountOfTransaction] ), 
            ALLEXCEPT( Raw_Transactions, Raw_Transactions[IncidentId] ) 
        )

        RETURN
        IF(
            Result = Raw_Transactions[CountOfTransaction],
            Result
        )
)
    
RETURN 
CALCULATE(
    COUNTX(
        _vTable,
        [@MaxTransaction]
    ),
    Raw_Transactions[TransactionType] <> "Closed"
)