first sorted value issue

[ioannagr]

Hello all,

i've got an issue where first sorted value can be multiple values

=FirstSortedValue([name], -Aggr(sum( {1} [countid]), [year], [name] ))

and in pivot table by year for name i get "-" because there are multiple names with the same sum... 

How can I fix this?

[Anil_Babu_Samineni]

How do you need? Perhapd this way

=FirstSortedValue(Concat(distinct [name], ','), -Aggr(sum( {1} [countid]), [year], [name] ))

[ioannagr]

Hello @Anil_Babu_Samineni  yes probably something like that, but this expression doesn't work. Gives error like "nested aggregation isn't allowed".

Thanks though 🙂

[Anil_Babu_Samineni]

can you share sample application where we can demon the same?