Forum Discussion
Countrows or Summarize
I worked around my issue by concatenating the columns I needed, then doing a countrows.
Or you can just skip the measure part and instead of adding the measure to the visual, add Appts[Patient ID] and select Count as aggregation for Appts[Patient ID]. Like this:
Thanks for the reply Erik, I will get better at articulating my questions.
I have a table [lets call it Appt], with the two fields.
I need tp identify if multiple appointments were made on the same day so I can trigger another formula to disregard one of them. for example.
If Joe made two appointments on one day, one with 'Doc x' and one with 'Doc y' then I want to be able to say, okay Joe had two appointments on the 24th, but for reporting purposes I want to ignore the appointment with 'Doc x'.
I have managed to get to a count of Appointments on a Day or Patients on a day but not a subset of both.
This is what I am trying so far.
Measure { Same Day Appointment Count 2 = COUNTA('Appt'[Patient ID]) }
Calculated Column { Same Day Appointment Count = (CALCULATE([Same Day Appointment Count 2],'Appt'[Revised Appointment Date])) }
The result is giving me 1 for "each appointment" but not a 2 for the two appointments on the same day.
Martin
I worked around my issue by concatenating the columns I needed, then doing a countrows.