Forum Discussion
Grouping
Hello everyone. I have the following data: As you can see it is the same client, who has been visited on 3 different days, and on some of those days there has been more than one meeting...
Try this!
Visits to Client = sumx(VALUES(Appointment[Meeting Date]),DISTINCTCOUNT(Appointment[Client]))