DISTINCT COUNT if Column A or Column B contain "X" value

[novotnajk]

Hi again, I have so many things to learn still with Power BI.  Appreciate any help on any of my outstanding questions.

Here is my next one...

I have three columns:

PATIENT ID

PRIMARY DIAGNOSIS

SECONDARY DIAGNOSIS

I'm trying to create a measure that counts distinct patients who have a particular diagnosis in either the PRIMARY or SECONDARY diagnoses columns.  For example:

PATIENT ID          PRIMARY DIAGNOSIS          SECONDARY DIAGNOSIS

123456789           Asthma                                 Diabetes

456789123           COPD                                    Asthma

741852963           Asthma                                 Cancer

963852741           Hypertension                        COPD

123456789           Influenza                               Asthma

I want to create a measure that says, Unique Asthmatics WHERE if PRIMARY DIAGNOSIS or SECONDARY DIAGNOSIS = "
Asthma, then = Unique Asthma Patient

From the above, I would expect my measure to say, "Unique Asthma Patients = 3

Help???!?!?!

[Anonymous · Accepted solution]

Hi,

You can create a measure as below:

Unique Asthma Patients = 
CALCULATE( DISTINCTCOUNT( Data[PATIENT_ID]),
FILTER( Data, Data[PRIMARY_DIAGNOSIS] = "Asthma" ||
Data[SECONDARY_DIAGNOSIS] = "Asthma"
)
)

Please accept this as a solution if it satisfies the requirement. Appreciate your Kudos. 🙂

Thanks.

[Anonymous · Accepted solution]

Hi,

You can create a measure as below:

Unique Asthma Patients = 
CALCULATE( DISTINCTCOUNT( Data[PATIENT_ID]),
FILTER( Data, Data[PRIMARY_DIAGNOSIS] = "Asthma" ||
Data[SECONDARY_DIAGNOSIS] = "Asthma"
)
)

Please accept this as a solution if it satisfies the requirement. Appreciate your Kudos. 🙂

Thanks.

[novotnajk · Accepted solution]

Awesome!  Thank you so much!  If you can help me with the other solutions, that would be great as well!