Pick ith element from concat or similar

[chrweber]

Hi, I wish to pick the i'th element of a concatenated selection

=pick(1, concat( [Field], ', ' ))

I would have thought that I should be possible however, currently the second argument is interpreted as a single argument and not as many.

Is my approach possible and am I just missing something?

[chrweber]

Yes, this works when only one is selected.

I want to combine it with a set analysis so that regardless of selection I can show the rank of the ith element

[tamilarasu]

Ah got it.

=Aggr(If(Field = '$(=SubField(GetFieldSelections( Field,',',3),',',2))', Rank(sum({1}[Numbers]))),Field)

[chrweber]

Exactly, I was just about to post the same thing. Thank you