Say I have a really simple fact table
CREATE TABLE FactSymptom (
and I have the following dimensions: Patient, Symptom, Calendar.
I can find all the Patients that have Symptoms A and B in SQL really easily...
WHERE Symptom = 'A'
WHERE Symptom = 'B';
How do I do something like this in DAX?
It looks like I could do it with
but it returns no rows... Is there a way to project just the PatientID?