Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |