title: Date equal to max date is not working in Tableau
body: <p>I need to model below query in tableau.</p>
  
  <pre><code>Select * from table where date = (Select max(Date) from table);
  </code></pre>
  
  <p>I have created a calculated field to filter data as below but its not working. I am selecting only true table.</p>
  
  <pre><code>max(Date)== Total(Max(Date))
  </code></pre>
  
  <p>Please suggest on the above.</p>