Distinct CountRows based on Date and Location

[adoster]

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

[amitchandak · Accepted solution]

@adoster , Try measure like

countrows(summarize(Table, table[Username], Table[Location], Table[date]) )