Dynamic Ranking based on date and key

Hi SunStorm,

Try the below for your measure:

Count of Key by Status = 
VAR MaxDate = MAX ( 'Calendar'[Date] )
VAR SelStatus = SELECTEDVALUE ( table_1[objective_status] )

-- summarizes the relevant columns, filtering by date
VAR Summarized = 
CALCULATETABLE (
    SUMMARIZE ( table_1, table_1[key], table_1[entry_date], table_1[objective_status] ),
    REMOVEFILTERS (),
    'Calendar'[Date] <= MaxDate
)

-- ranks the summarized table for the latest entry date
VAR Ranked =
ADDCOLUMNS (
    Summarized,
    "Objective Rank",
        ROWNUMBER (
            Summarized,
            ORDERBY ( table_1[entry_date], DESC ),
            DEFAULT,
            PARTITIONBY ( table_1[key] )
        )
)

-- filters the ranked table for only the most recent entry date and matching objective status
VAR Filtered =
FILTER (
    Ranked,
    [Objective Rank] = 1 &&
    [objective_status] = SelStatus
)

RETURN COUNTROWS ( Filtered ) + 0

I added comments in the measure to illustrate the logic, but essentially the measure:

1. filters for only the relevant columns and records
2. ranks the table above so we can filter for only the latest entry date per key
3. filters the above table for only the latest entry dates and relevant objective status
4. counts the rows in the above table

This is what my data model looks like:

Let me know if that's not what you were looking for.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)