Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Syndicate_Admin
Administrator
Administrator

Grouping

Hello everyone.

I have the following data:

LFDSTHGroup_0-1685102681802.png

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

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

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)

LFDSTHGroup_0-1685364168195.png

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)

LFDSTHGroup_1-1685364378413.png

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
Syk
Super User
Super User

Try this!

Visits to Client = sumx(VALUES(Appointment[Meeting Date]),DISTINCTCOUNT(Appointment[Client]))

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.