How to avoid double counting when an item links to multiple items in a different column

[VModani]

I have data that among other things contains names and Offer/Reject action. I want to find how many names are in each action Reject or Accept. I can create 2 seperate measures for both actions and do distinctcount to count each individually. But that results in some doublecounting as some name are first reject and then offered so are counted seperately. 

I want to count them seperately only but need to remove if they were in the other action before.

Take John as an example below. He appears 4 times, 2 reject and 2 offered. I created a measure of Distinctcount and filtered by action. so I get 1 in offer and 1 in reject. I only want 1, based on the newest entry.

Thanks!!

Date	Name	Action
1 Feb	John	Reject
1 Feb	John	Reject
2 Feb	Adam	Reject
2 Feb	Robert	Offer
3 Feb	John	Offer
4 Feb	Mike	Reject
4 Feb	Mike	Offer
5 Feb	John	Offer

[Jihwan_Kim · Accepted solution]

Hi, 

I am not quite sure which action does Mike belong to. On the same day, Mike's result is Reject and Offer.

I guess Mike belongs to both, and the below calculation shows like this.

Please check the attached pbix file.

Distinctcount name by last action only: =

IF (

HASONEVALUE ( Data[Action] ),

CALCULATE (

COUNTROWS ( Data ),

TREATAS (

GROUPBY (

ALL ( Data ),

Data[Name],

"@lastactiondate", MAXX ( CURRENTGROUP (), Data[Date] )

),

Data[Name],

Data[Date]

)

)

)

[VModani]

Sorry for not making the sample properly. Mike belongs to the Offered action. I think date/time datatype can solve that. The solution itself if working. Thank You!