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.
Trying to CountRows except when User is in the same location on the same day.
In example below Mickey Mouse would be counted 3 times because Row 3 is on the same day and same location.
Example Table:
User Name | Location | Date | Color |
Mickey Mouse | A | 7/1/2022 | Red |
Mickey Mouse | B | 7/1/2022 | Red |
Mickey Mouse | A | 7/1/2022 | Blue |
Mickey Mouse | A | 7/2/2022 | Red |
Donald Duck | C | 7/1/2022 | Red |
Solved! Go to Solution.
@adoster , Try measure like
countrows(summarize(Table, table[Username], Table[Location], Table[date]) )
@adoster , Try measure like
countrows(summarize(Table, table[Username], Table[Location], Table[date]) )
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |