I need help finding the count of unique encounters for data similar to the example below. A unique encounter = unique ID at a unique location receiving a unique service on a unique date by a unique provider. I need to be able to filter and run unique encounter counts based on those variables, i.e. unique encounters at location VA vs CA, for service a vs b vs c, on [date], and by provider x vs y.
Thanks so much for any guidance!
ID | LOCATION | SERVICE | SERVICE DATE | PROVIDER |
1 | VA | a | 12/1/2021 | x |
1 | VA | a | 12/1/2021 | x |
1 | VA | a | 12/1/2021 | y |
1 | VA | b | 12/1/2021 | x |
1 | VA | a | 12/2/2021 | x |
1 | VA | b | 12/2/2021 | y |
1 | VA | c | 12/1/2021 | x |
1 | VA | c | 12/3/2021 | x |
1 | VA | c | 12/2/2021 | y |
2 | CA | a | 12/1/2021 | x |
2 | CA | a | 12/1/2001 | y |
2 | CA | c | 12/1/2021 | x |
2 | CA | c | 12/1/2021 | x |
2 | CA | b | 12/2/2021 | x |
2 | CA | b | 12/2/2021 | y |
2 | CA | a | 12/2/2021 | x |
2 | CA | b | 12/2/2021 | x |
Solved! Go to Solution.
@Anonymous so this works for you I guess
Measure3 =
COUNTROWS (
SUMMARIZE (
'Table',
'Table'[ID],
'Table'[LOCATION],
'Table'[PROVIDER],
'Table'[SERVICE DATE],
'Table'[SERVICE]
)
)
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
@Anonymous did you mean this
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
I beleive that just counts the rows without any filters to identify unique encounters. For example, the first two rows should only count as 1 encounter because it's the same ID, at the same location, receiving the same service, on the same service date, by the same provider. The third row, however, is by a different provider to that should count as another unique encounter.
@Anonymous so this works for you I guess
Measure3 =
COUNTROWS (
SUMMARIZE (
'Table',
'Table'[ID],
'Table'[LOCATION],
'Table'[PROVIDER],
'Table'[SERVICE DATE],
'Table'[SERVICE]
)
)
Proud to be a Super User!
New Animated Dashboard: Sales Calendar