When duplicaets keep value with most recent date

[Anonymous]

Hello everyone,

I had to find the most recent Status Date for each project, but for some project i have multiple results (usually 2) and don't understand how for some it works but for others doesn't.

My solution to find the most recent Status is the following :

So Most Recent Date is the filter I use so it could only give me the first (1) most recent result.
What am I missing ?

Thanks in advance !

[amitchandak]

@Anonymous , Create measures like this 

Measure =
VAR __id = MAX ('Table'[ID] )
VAR __date = CALCULATE ( MAX('Table'[DAte] ), ALLSELECTED ('Table' ), 'Table'[ID] = __id )
CALCULATE ( MAX ('Table'[Status] ), VALUES ('Table'[ID] ),'Table'[ID] = __id,'Table'[DAte] = __date )