Measure that counts Active subscribers

Hello,

This is a continuation ticket from a previous ticket I opened, following my prompting mistakes, which accumulated a lot of messages that were simply difficult to follow and I was advised to open a new card. (https://community.powerbi.com/t5/Desktop/Product-table-and-subscription-table/m-p/2679518#M938530)

My Issue:

Attached File

In advance I should mention that a downloadable file is attached, there is also a formula that needs a little more precision (the formula was written by tamerj1, many thanks to him for the help)

Attached File: https://we.tl/t-LtP4V0L6H0

schema:

Desired results: 

I need a measure that counts how many Active Status was in every month (or year depending on the filter context).

The rules are:

1. count only if in the end of the period the Subscription ID was in status "Active"

2. if there is in the same Status Date a status change, we need to take the highest "Status History ID" (PK) so this field will be the "Tiebreaker"

 3. it should count as "Running Count", so if a Subscription ID was Active at Jan-22 and there is no status change whill Feb, Mar... the measure still needs to count it on those months

Hope every thing is clear.