Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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]
)
)
@Anonymous did you mean this
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]
)
)
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
53 |