How to get Top State Name and Value in KPI card

[sunil-kumar5]

Hi Community,

I want to show Top state name who made highest sale in current year which is till date. I mean to say the KPI card should present like [Chennai 125K]. Also it would be calculated based on count distinct sales id as there will be duplicates.

Sales ID	State Name
10001	Delhi
10002	Maharastra
10003	Chennai
10004	Delhi
10005	Maharastra
10006	Chennai
10007	Delhi
10008	Maharastra
10009	Chennai
10010	Delhi
10011	Maharastra
10012	Chennai
10013	Delhi
10014	Maharastra
10015	Chennai

Please advise.

Thanks

[Steven_Haught]

You could try this as measure in KPI, 

FirstSortedValue(StateName &' ' & Sales , -Sales)

[Steven_Haught · Accepted solution]

Or if needing the sum of sales for the region to control the name:

=FirstSortedValue(StateName &' ' &Aggr(Sum(Sales), StateName), -Aggr(Sum(Sales), StateName))

[sunil-kumar5]

Solved!! Thanks for your help Steven:-)