• I have a really simple one in PowerBI with only a handful of Patients. It's really small on purpose, because I only need a few records to prove the query is right.

    The basic structure is

    Patient--(1,M)--PatientSymptom---(M,1)--SymptomList

    The file should be attached. <G>

    The problem I'm having (because I'm not very good at DAX) is that I want to project only the PatientID so that I can use set operations like INTERSECT and MINUS (well, the DAX version...)

    Thanks!