Dax for grouping by compliance?

[ranis1227]

Hello,

I am trying to get compliance whether the patient took a drug screen or not.  Here are some example data:

For clinic A the compliance is 87.5%, 7 (number of distinct patients who took a drug screen)/8 total number of  distinct patients in clinic A.  For clinic B the compliance is 50% (1/2).  

Is there a way to do this with dax?  Please reach out if you need additional information.  

[v-cazheng-msft]

Hi @ranis1227 ,

You may try this Measure.

compliance =
VAR PatientsWithGrugScreen =
    CALCULATE (
        [Distinct Count Patients],
        FILTER ( DrugScreen, DrugScreen[GrugScreen] = "Y" )
    )
VAR ClinicPatients =
    CALCULATE ( [Distinct Count Patients], VALUES ( DrugScreen[Department] ) )
RETURN
    DIVIDE ( PatientsWithGrugScreen, ClinicPatients )

The result looks like this.

Also, attached the pbix file as reference.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

[ranis1227]

Thank you very much. This works perfectly. 

[amitchandak · Accepted solution]

@ranis1227 , try measure

Divide(calculate(sum(Table[patients]), filter(Table, Table[drugscreen] = "Y")),sum(Table[patients]))

[ranis1227]

Amit, 

I tried it and it worked for the sum of total patients. 

However, I need it for the distinct number of patients.  I used 

Distinct Count Patients = DISTINCTCOUNT(DrugScreen[PTNAME]).  There are duplicate patient visits for each clinic.