Creating a measure to count "Appointments" (date), avoiding duplicates in two columns

[Anonymous]

Hello folks,   I've gotten some great advice, help, and tips from you in the past and I was hoping you could help again.  

I have a dataset where I need to count distinct "appointments".  The problem is, sometimes those appointments are  sometimes on two people's calendars at the same time, and only count as one visit.  

What I'm looking for is a way to say: if there is more than one appointment on a calendar day with the same subject ID (unique value), only count ones assigned to a particular group (already configured the groups).  

I started creating a measure, but I didn't get far.  

I know it will probably be some combination of COUNT and FILTER, but I'm struggling to find the right one.  

Let me know if I can clarify anything.

Thank you for taking the time!

[v-chenwuz-msft · Accepted solution]

Hi @Anonymous , 

Please try this code:

COUNT MEASURE = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Appointments] ),
    FILTER ( ALLSELECTED ( 'Table' ), [group] = SELECTEDVALUE ( 'Table'[group] ) )
)

If you need more help, please provide some example data and expect result.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SpartaBI]

@Anonymous can you share a sample data and write here what ia the desired result