Dax measure to keep one row per employee with the most recent date

[pierreemma]

This is my table :

I need to calculate the number of ids declined by value_bet, keeping only the value corresponding to the most recent row (i.e. the min of rank_bet for each employee).

I've tried using this expression

CALCULATE(DISTINCTCOUNT(bet[id]), bet[rank_bet]= MINX(FILTER(bet, bet[id] = LASTNONBLANK(bet[id], bet[id])), bet[rank_bet]))

but the calculation of Min(rank_bet) is wrong when I break it down by value_bet: I get the impression that my measure takes the Min(rank_bet) by value_bet group and not grouped by id.

Example of expected result : 

• without date filter :

• with date filter : from 27/10/2021 to 08/12/2022 : 

[AlexisOlson · Accepted solution]

I'm not sure why this filter is needed for a distinct count of id calculation but I'd approach it like this:

VAR _MinRanks_ =
    SUMMARIZE (
        bet,
        bet[id],
        "MinRank", MIN ( bet[rank_bet] )
    )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( bet[id] ),
        TREATAS (
            _MinRanks_,
            bet[id],
            bet[rank_bet]
        )
    )

[pierreemma]

thank you, it works perfectly!