Rankx: Finding the Last Transaction per Contract within a Date Period

Good day all,

I have a table with multiple banking transactions in per contract. A batch of transactions is run on a pecific date for multiple contracts. The client wants to see what all the last transactions per contract are and to see a summary table of all the last transaction statuses and the amount of contracts associated to each, based on a date slicer.

So if this is the sample data for instance:

Once the client selects lets say 1/30/2025 (which is the MandateEffectiveDate), the two visuals must display

Detail: Show only the last transaction per contract and all the relevant info, so:

And the other table must count the contracts within the table above and group the according the transaction Status:

If Payment successful is selected in the second table it must filter the second table accordingly to only show that one contract.

So I added a calculated column to rank each transaction per contract:

TransactionRank = 
RANKX(
    FILTER(
        MandatesData,
        MandatesData[ContractNo] = EARLIER(MandatesData[ContractNo])
    ),
    MandatesData[TransactionDate],
    ,
    ASC,
    Dense
)

Then I created a measure to determine the last transaction - based on the dynamic date slicer:

MaxTransactionRankMeasure = 
CALCULATE(
    MAX(MandatesData[TransactionRank]),
    FILTER(
        ALLSELECTED(MandatesData),
        MandatesData[ContractNo] = MAX(MandatesData[ContractNo]) &&
        MandatesData[MandateEffectiveDate] <= MAX(MandatesData[MandateEffectiveDate])
    )
)

Then a flag measure to use as a filter on the first table:

IsLastTransactionMeasure = 
IF(
    MAX(MandatesData[TransactionRank]) = [MaxTransactionRankMeasure] &&
    NOT ISBLANK(MAX(MandatesData[TransactionRank])),
    1,
    0
)

And if I apply this as a filter to the first table, where IsLastTransactionMeasure = 1, it creates the desired result within the table after selecting the relevant date range.

But I now cannot get the second table visual to group the Transaction statuses and count the contracts associated. I tried this measure but it doesn't produce the desired relust and if you select a status the incorrect amount of contracts appears in the first table

TotalContracts = 
SUMX(
    VALUES(MandatesData[Status]),
    CALCULATE(
        DISTINCTCOUNT(MandatesData[ContractNo]),
        FILTER(
            ALLSELECTED(MandatesData),
            [IsLastTransactionMeasure] = 1
        )
    )
)

No idea if any of this makes any sense at this point