Count of unique occurrences with multiple criteria/exceptions

[Anonymous]

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

[smpa01]

@Anonymous  did you mean this

[Anonymous]

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.

[smpa01 · Accepted solution]

@Anonymous  so this works for you I guess

Measure3 = 
COUNTROWS (
    SUMMARIZE (
        'Table',
        'Table'[ID],
        'Table'[LOCATION],
        'Table'[PROVIDER],
        'Table'[SERVICE DATE],
        'Table'[SERVICE]
    )
)