![]() ![]() ![]() 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”) 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. Or use the web version which has some limitations compared to the desktop one. You can run it via a windows virtual machine. =calculate(CONCATENATEX(values(ServiceDetails), ServiceDetails,”, “), ServiceDetail=”HT”) Pbi desktop on Mac does not exists and as far as I know it's not even planned. 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 |