Measure to get Value with the highest (SUM)

[Anonymous]

Hi, hopefully someone can help me

I have a table in my Tabular Model that looks like the below

Date	Description	Calls
01/01/2020	IT	345
01/02/2020	Legal	23
01/02/2020	Helpline	2345

What I want to build is a measure that just brings me the Description with the highest Calls in the period. So for the above, the Measure would show "Helpline" as it has 2345 calls.

I have created the below but it doesn't work for me and gives me the wrong description - can anyone help?

ParallelName:=CALCULATE(LASTNONBLANK('Productivity'[Description],0),FILTER(VALUES('Productivity'[Description]),rankx(all('Productivity '[Description]),[Calls],,ASC) = 1 ))

[amitchandak]

@Anonymous , Why asc sort when you need highest?

try

DRank = RANKX(all(Table[Description]),[Calls])

Rank 1 top = maxx(filter(VALUES(Table[Description]),[DRank]=1),Table[Description] )

or

Top 1 Rank = CALCULATE(max(Table[Description]),TOPN(10,all(Table[Description]),[Calls],DESC),VALUES(Table[Description]))

[P_D_G · Accepted solution]

Hi @Anonymous ,

this should answer your question:

https://community.powerbi.com/t5/Desktop/DAX-Retrieve-a-value-in-one-column-based-on-MAX-in-another/td-p/606141

Please give kudos to the original responder in the linked post.

[Anonymous]

Hi, this works perfect for me thank you.

What would be the best way of using this to get the 2nd highest SUM?