title: Return only single max value row in Power BI Desktop
body: <p>I have the following table of Parts which are sold for a particular job, which is the Order Number.</p>
  
  <p>I am trying to extract just the Description of the most expensive part so that I can put it onto a single value card.</p>
  
  <p>I have tried for a day mucking around with CALCULATE, MAX, TOP, SELECTEDVALUE, I cant seem to figure it out. I'm sure it is something simple too...</p>
  
  <p>Would appreciate it if somebody can help me retrieve it in a way that I can see what I missed and learn for future.</p>
  
  <p>My page is filtered by DrillThrough on the Order Number which filters the parts list for me.</p>
  
  <p><a href="https://i.stack.imgur.com/NooFm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NooFm.png" alt="enter image description here"></a></p>
  
  <p>Essentially, I just want the card to show 'PUMP,DTH,ELE'. My approach was to just select the top 1 row when the parts list is sorted descending by Amount in LC but it so far has not been as simple as that :(</p>
  
  <p>Should it be a calculated column or measure on my Order table which has that string?</p>