Forum Discussion
Problem with visits per patients
I am creating a table and wanting to include the number of visits completed per patients in each calendar year. However, when I do
Visits per patient =
DIVIDE('New Appointment_Fact'[Appointment Completed Numerator], 'New Appointment_Fact'[patientid])
it gives me the wrong visits per patients number.
For example, for CY23 if I divide 9981 / 3455 the visits per patient should be 2.89, not 3.84 as it shows up. Any ideas on what is wrong?
