Distinct count on a table visual

Hi, To count distinct missed appointments per customer and display it in a table, follow these steps

Step 1. Create a Calculated Column-- Add a column to your table to count the number of missed appointments per customer.

MissedAppointmentsCount = CALCULATE(COUNTROWS(Meetings), FILTER(Meetings, Meetings[CustID] = EARLIER(Meetings[CustID]) && Meetings[AppointmentType] = "First" && Meetings[AppStatus] = "DNA"))

Step 2. Add the Column to the Table Visual-- Include the new 'MissedAppointmentsCount' column in your table visual along with the other relevant columns.

This approach ensures you can see the number of missed appointments for each customer directly in your visual.

Please let me know if your question is answered.

Regards,
Chiranjeevi kudupudi