I have a number of patients that have received testing. I’m trying to determine how many of those patients have been tested more than once. I have a unique key for each result but no unique ID for each patient. As a result, I am trying to count how many potential repeat patients there are based on values like phone number, dob, first name, and last name.
The outcome I am hoping for is something like if dob, first_name, last_name & phone match than count how many times that patient has come.
I’m having a hard time trying to write this in Dax.
I tried using something like this below but Earlier is not working for me at all:
FILTER ( yourTable, EARLIER ( yourTable[Col A] ) = yourTable[Col A] ),
Any help or thoughts would be much appreciated.