Forum Discussion

Elisa112's avatar
Elisa112
Helper V
2 years ago
Solved

Distinct count on a table visual

Hello Experts   I am trying to resolve how to count distinct values in a table visual, for our appointments table I need to count the number of appointments missed for each customer.  I have tried ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

Elisa112's avatar
Elisa112
Helper V
2 years ago

Hello

Apologise  I made a mistake, the correct version is below

 

CustID     AppointmentType      AppStatus   AppID    AppDate         Meetings Missed

001            First                          DNA            002             1 June             2

002            First                          DNA            004             5 June             2

 

I need to find the number of times a customer has missed the first appointment,  (DNA = did not attend).

Thanks for your assistance.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Create a measure as below. It might works for your requirements.


MissedFirstAppointments =
CALCULATE(
COUNTROWS(Meetings),
Meetings[AppointmentType] = "First" && Meetings[AppStatus] = "DNA"
)