Unable to get accurate count using CALCULATE COUNTROWS with Filter

[tomperro]

I am having an issue getting a total count of a measure.

I am trying to get a total count of my measure in NC Follow Up Required = "YES"

NC_Follow_Up_Required =

IF( AND([Date_of_Last_NC] = [Date_of_Last_NC_Follow_Up], DATEDIFF([Date_of_Last_NC],TODAY(),DAY) >30 ), "YES", IF([Date_of_Last_NC_Follow_Up] > [Date_of_Last_NC],"NO",""))

Count_of_NC_Follow_Up_Required_YES =

CALCULATE(COUNTROWS(Contact), FILTER(Contact, [NC_Follow_Up_Required]="YES"))  

In the first table, you can see there are 6 rows where NC Follow Up Required = YES but in the second table, it is only showing 4.
It looks like my DAX is not counting the duplicate name, Johnson.

Employee information comes from my contact table and NC Test number comes from another table.

[audreygerred]

Could you share your pbix file so I can try to assist with troubleshooting?

[tomperro]

Unfortunately it contains data that I can not share 😞

[tomperro]

@audreygerredUnfortunately it contains data that I can not share