I am building a dashboard for my brother’s medical practice. The data is coming from a practice management system and contains tables such as:
- Patient profiles
I created a date table for use in patient appointment report pages and linked it to appointments table. I then realized I needed a date table for filtering charges so created a separate Charges Date Table.
Now here’s an example of the problem I am running in to:
I have a measure called # patient encounters = COUNT(Patient_Encounters[Encounter_UID]). It gets filtered down in a report page that looks at patient volume metrics based on the Appointments Table.
Now I am creating a separate report page for charges, which has its own date table. Naturally, if I add the measure # patient encounters to that page I get the total patient encounters because the Charges Date Table is not filtering the measure.
I don’t want to affect the use of the patient encounter measure in other pages by making it actively related to the charges date table. What would you suggest I do?
- Create a duplicate patient volume measure which uses the relationship between charges date table and appointments?
- Replace the # patient encounter measure with something smarter, and what would that be?
Here’s the graphic for my situation: