I’m making a report for our rehabilitation department within a hospital, and need to display a filtered list, based on 2 separate criteria.
Some background might help: patients come to our hospital, see 1 or more doctors, and then get referred to rehabilitation to see therapists.
One report I’ve made filters all of the fTherapistVisits table to show the selected therapist (from the dimension table: dTHERAPIST[Therapist Name]) and their respective current list of patients (each of which have a unique Medical Record Number - MRN). What I’d like to be able to do, is when a Single therapist is selected (in the Therapist slicer, “Jane” in the drawing below) AND a single Patient is selected in the table (which is now filtered as Jane’s active patients, with “Pierre” selected here) then in the separate “Treating Doctor” table, show all the doctors who this patient has seen - in this case there are visits associated with Dr Smith, Dr Death, and Dr Who.
Currently, I can create the therapist slicer and show the current therapist list of patients, but can’t get the associated doctors to display. I’ve shown below a schematic of the tables - fact tables at the bottom, and dimension tables at the top (I can’t show the actual screen grab, or ‘real’ reports because of patient privacy laws)
All help gratefully recevied,