I would greatly appreciate some advice on how to approach this problem. I have an existing measure for this count:ĭistinct HT =calculate(DISTINCTCOUNT(ServiceDetails), ServiceDetails=”HT”) This service also streams apps to iPads, tablets, and other devices. What I would like to do is to create a matrix/pivot table where I can select a particular employee, and for each Client (in rows), display the concatenated names of contacts for which other employees under the same Practice have service interactions – but the particular employee does not.Įven better (not sure if this part is actually possible), it would be great if the names appeared in descending order of how many interaction records exist for the contact. Vince, another option to look at is, which can stream Power BI to your Mac from the cloud: Run Power BI Desktop on Mac - This doesn't require running any VMs on your Mac. =calculate(CONCATENATEX(values(ServiceDetails), ServiceDetails,”, “), ServiceDetail=”HT”) As depicted, I have a data table containing service interaction records that is linked to an index table containing employee names and their practice.Ĭurrently I use a simple measure to concatenate the names of clients (“Contact Name”) who have received high touch (“HT”) service:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |