Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
What I have is the data of the count of meetings I have had with that client (5), but what I am also looking for is the number of visits per client (3), regardless of how many meetings I have had.
That is, I seek to group by date: I have visited the Contoso client on (3) different dates, in this year (chosen period)
I have tried with this formula, but I do not achieve the desired result
CALCULATE(COUNT(Appointments[Client]),FILTER(Appointments,DISTINCT(Appointments[Meeting Date])),USERELATIONSHIP('Chosen Period'[Date],Appointments[Meeting Date]))
Thanks for the help
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)
Try this!
Visits to Client = sumx(VALUES(Appointment[Meeting Date]),DISTINCTCOUNT(Appointment[Client]))
User | Count |
---|---|
128 | |
72 | |
70 | |
58 | |
53 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |