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...
Thank you very much for the reply.
Although the solution you propose only works if the data is filtered by a single client (1): meetings (5) and visits (3)
But when I want to see the visits of all customers, then the data is not correct (it should be a number between 187 and 297)
Number of visits made (current) = CALCULATE(SUMX(VALUES(Dating[Start date]),DISTINCTCOUNT(Dating[_sth_cuenta_value])),USERELATIONSHIP('Current Period'[Date],Dating[Start date]))
Where can the error lie?
Thanks for the help