Forum Discussion

ahhk2000's avatar
ahhk2000
Copper Contributor
Oct 25, 2022

PowerPivot/DAX - comparison of one column to another column

Hi experts, I currently have a PowerPivot dashboard where I use measures to concatenate and return the names of clients who have received certains types of service:

Call Recipients
=calculate(CONCATENATEX(values(ServiceHistory[Contact Name]), ServiceHistory[Contact Name], “, “), ServiceHistory[Service Type]=“Call”)

Meeting Recipients
=calculate(CONCATENATEX(values(ServiceHistory[Contact Name]), ServiceHistory[Contact Name], “, “), ServiceHistory[Service Type]=“Meeting”)

I'm trying to figure out how to set up a measure(s) to return the names of clients who have receive one type of service (Call), but have not received another type (Meeting). Any idea how this can be done?

Thanks in advance for any advice!

No RepliesBe the first to reply