title: DAX - RANKX Using Two Calculations -
body: <p>I have a data table that contains transactions by supplier. Each row of data represents one transaction. Each transaction contains a "QTY" column as well as a "Supplier" column. </p>
  
  <p>I need to rank these suppliers by the count of transactions (Count of rows per unique supplier) then by the SUM of the "QTY" for all of each supplier's transactions. This needs to be in 1 rank formula, not two separate rankings. This will help in breaking any ties in my ranking.</p>
  
  <p>I have tried dozens of formulas and approaches and can't seem to get it right. </p>
  
  <p>See below example:</p>
  
  <p>Suppliers ABC and EFG each have 4 transactions so they would effectively tie for Rank 1, however ABC has a Quantity of 30 and EFG has a QTY of 25 so ABC should rank 1 and EFG should rank 2. </p>
  
  <p>Can anyone assist?</p>
  
  <p><a href="https://i.stack.imgur.com/vCsCA.png" rel="nofollow noreferrer">https://i.stack.imgur.com/vCsCA.png</a></p>