Say I have a really simple fact table
CREATE TABLE FactSymptom (
PatientID INT,
Symptom VARCHAR(20),
Grade TINYINT,
ConsentDate DATE
);
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...
SELECT PatientID
FROM FactSymptom
WHERE Symptom = 'A'
INTERSECT
SELECT PatientID
FROM FactSymptom
WHERE Symptom = 'B';
How do I do something like this in DAX?
It looks like I could do it with
INTERSECT(FILTER('FactSymptom',[Symptom]='A'),FILTER('FactSymptom',[Symptom]='B'))
but it returns no rows... Is there a way to project just the PatientID?