So I need to calculate the return to hospital percentage when we see a patient and when we do not see a patient to compare (and prove that if we have seen the patient, our RTH is low which means good)
I have table1 where all the data is compiled. However I am interested only in 5 specific facilities (my data has 200+ facilities) and I am interested in only 2024 september (my data has 3 years worth data)
Table2 has the patients that returned to hospital and if they were seen by us or no.
Table1
Table2
Measures created
I have all measures created in one table
Here I am calculating if they were consulted by us or no. I want to use these numbers as the numerator where calculating return to hospital
Next I need to figure out measures for the other table where it would take only september and only specific location within the location column. Both these tables have a many to many relationship.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
