Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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]
)
)
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
62 | |
61 | |
55 | |
38 | |
27 |
User | Count |
---|---|
83 | |
61 | |
45 | |
41 | |
39 |