Refining CONCATENATEX measure

[mrhk22]

Hi Experts,

I have the following measure"
=CALCULATE(CONCATENATEX(VALUES(Service Details[Contact Name]), Service Details[Contact Name], “, “))

...and hope to expand it in order to:

i) Filter according to criteria in another table column: Service Details[Service Type]=“High Touch"
ii) Sort the returned values by descending order of frequency

Is this possible? Thank you.

 

[mamady]

It is easily doable if you have Office 365 by integrating the new formulas =Sortby(Filter(

Regards

 

[mrhk22]

U

It is easily doable if you have Office 365 by integrating the new formulas =Sortby(Filter(

Re

Unfortunately I'm on Excel 2016

 

[mamady]

U

Unfortunately I'm on Excel 2016

I can propose a formula. Wouldn't be optimal, but it would do the job.
Can you please share a data set sample via XL2BB?

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

Regards

 

[mrhk22]

Thanks... I guess the need to sort is not that important for now and I've added a filter for the Service Type into Calculate