I am currently using the following measure that returns the contact names of clients for whom there are "Meeting" service records in a table:
Meeting Recipients
=calculate(CONCATENATEX(values(ServiceHistory[Contact Name]), ServiceHistory[Contact Name], “, “), ServiceHistory[Service Type]=“Meeting”)
I set this up in a pivot table with an Account Name column (ServiceHistory[Account Name]) and a column with the "Meeting Recipients" from that account.
How would I modify the measure so that it returns contact names with "Meeting" service records who do not have any"Consultation" service records (i.e. ServiceHistory[Service Type]=“Consultation”)?
Thank you for pointers.
Meeting Recipients
=calculate(CONCATENATEX(values(ServiceHistory[Contact Name]), ServiceHistory[Contact Name], “, “), ServiceHistory[Service Type]=“Meeting”)
I set this up in a pivot table with an Account Name column (ServiceHistory[Account Name]) and a column with the "Meeting Recipients" from that account.
How would I modify the measure so that it returns contact names with "Meeting" service records who do not have any"Consultation" service records (i.e. ServiceHistory[Service Type]=“Consultation”)?
Thank you for pointers.