May 17, 2016 at 10:21 pm
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?
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy