DAX - Distinct count of Patients, per Day, per Provider

[adoster]

I have built a statement to count the distinct number of Patients seen in a day.

PatientDistinctByDate =
var tmptable =
SUMMARIZE('Dates','Dates'[Date], "DistinctCount",DISTINCTCOUNT('All Data'[PAT_ID]))
RETURN SUMX(FILTER(tmptable,[Date]<= MAX('Dates'[Date])),[DISTINCTCOUNT])

I am having difficulty adding to this statement so that if they saw a different Provider(s) in the same day it will count that patient again.

Example...

IF John Smith saw Dr. Acula twice on 4/5/23 = 1 count

IF John Smith saw Dr. Acula twice & Dr. Zebra on 4/6/23 = 2 count

IF John Smith saw Dr. Acula, Dr. Zebra, & Dr. House twice on 4/7/23 = 3 count

[jdbuchanan71 · Accepted solution]

@adoster 

I have someting similar in my model.  I utilize the Claims table to get the [Visit Count].

Visit Count =
COUNTROWS (
    SUMMARIZE (
        CLAIM,
        CLAIM[Subscriber_Member_ID],
        CLAIM[Service_Date],
        CLAIM[Provider_ID]
    )
)

[DOLEARY85]

Hi,

try this:

Measure 3 = CALCULATE(DISTINCTCOUNT('Table'[Doctor]),ALLEXCEPT('Table','Table'[Doctor],'Table'[Date]))

data provided (left) after measure (right): 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍