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!