Forum Discussion
Distinct Service Date Count For Each Month
I have a dataset that contains patient visits by date for each month for Calendar Year 2023. What I am trying to do is to do a distinct count of the patient visit days or the service dates. The ser...
I can't be sure, but it looks like you have no date table, but are instead using one giant table with date hierarchies in more than one place. No offense meant, but there is a lot wrong with this data model.
I would remove the hierarchy on Service Date and DOB. Then place Patient and then Month "on rows". Then, your measure is Patient Visits = COUNT(TableName[Service Date]).
But really, you need a date table.
--Nate