title: Find Max for each day in PowerBI and DAX
body: <p>I am trying to find the maximum route for each day based on the count of cars in PowerBI/DAX.
  An example of my data is as follows:</p>
  
  <pre><code> Date         Route      Count
   01-Nov-17     A           10
   01-Nov-17     B           5
   02-Nov-17     A           2
   02-Nov-17     C           22
   03-Nov-17     B           2
  </code></pre>
  
  <p>Hence I want to find the max count of route for each date and display the results of a table like so...</p>
  
  <pre><code> Date         Route      Count
   01-Nov-17     A           10
   02-Nov-17     C           22
   03-Nov-17     B           2
  </code></pre>
  
  <p>Any suggestions would be very much appreciated.</p>
  
  <p>Thanks,
  Fiona</p>