Forum Discussion
adoster
Resolver I
Resolver IDistinct CountRows based on Date and Location
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 |
adoster , Try measure like
countrows(summarize(Table, table[Username], Table[Location], Table[date]) )
1 Reply
- amitchandak
Super User
adoster , Try measure like
countrows(summarize(Table, table[Username], Table[Location], Table[date]) )