Top Partner with current year

[sunil-kumar5]

Hi All,

I want current year top partner name with distinct license number , I got the top partner name on my KPI however not able to set it based on current year. Please advise

=FirstSortedValue([Partner Name] &' ' &Aggr(Count(distinct(LicenceNo)), [Partner Name]), -Aggr(Count(distinct(LicenceNo)), [Partner Name]))

Thanks

[Vegar]

Try to add set analysis to your expression. 

=FirstSortedValue({<[Year] ={'$(=year(today()))' } >} [Partner Name] &' ' &Aggr(Count(distinct(LicenceNo)), [Partner Name]), -Aggr(Count(distinct(LicenceNo)), [Partner Name]))

[sunil-kumar5]

Hi Vegar,

Thanks for your help.

Actually I already tried with the same but not success I am still getting top partner with license number but not for current year.

Is there any other way?

Thanks