if two values are the same return value of 1

[mforest]

Hello! 

Hoping someone can help with the DAX formula I need. I've been searching and trying, but I just cannot seem to get it right. 

I unpivoted a table of appointments and now have several hundred "duplicate" appointments. I need to know a count of total appointments that I will use as a measure on several visualizations. Since people can come more than once, distinct count does not work for this case. I essentially am hoping for a measure that says, if "person name" and "date of appointment" are the same, view that as 1 value. For the table value below, I would hope that the measure would return a value of 3. 

Person Name	Date of Appointment
Person 1	June 1
Person 1	June 1
Person 1	June 1
Person 2	June 1
Person 2	June 1
Person 1	June 3
Person 1	June 3

Thanks!

[mahoneypat · Accepted solution]

You can try this one, replacing Table with your actual table name

NewMeasure = COUNTROWS(SUMMARIZE(Table, Table[Person Name], Table[Date of Appointment}))

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[mforest]

This seemed to work! Thanks! I also realized I could concatenate the two columns and then create a measure of distinct values on that column. 

Thanks again!