Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. 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 April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
74 | |
70 | |
70 | |
45 | |
41 |
User | Count |
---|---|
49 | |
46 | |
28 | |
28 | |
28 |