title: PowerBI query doesn't work with date filter
body: <p>I have this DAX:</p>
  
  <pre><code>Earned Daily =
  VAR d = SELECTEDVALUE ( 'P6 Update'[Date] )
  RETURN
  IF (
      'Data for Pivot'[Date] &lt;= d
          &amp;&amp; 'Data for Pivot'[Act Rem] = "Actual Units"
          &amp;&amp; 'Data for Pivot'[Type] = "Current",
      'Data for Pivot'[Value],
      0
  )
  </code></pre>
  
  <p><code>'P6 Update'[Date]</code> is attached to a Slicer (single select date dropdown).</p>
  
  <p>I see that the date is being correctly set but when I try to use the date to filter it doesn't work.</p>
  
  <p>If I do this:</p>
  
  <pre><code>Earned Daily =
  IF (
      'Data for Pivot'[Date] &lt;= DATE ( 2018, 4, 19 )
          &amp;&amp; 'Data for Pivot'[Act Rem] = "Actual Units"
          &amp;&amp; 'Data for Pivot'[Type] = "Current",
      'Data for Pivot'[Value],
      0
  )
  </code></pre>
  
  <p>The data is filtered correctly.</p>
  
  <p>What's the problem with the original code?</p>
  
  <p><strong>#######</strong></p>
  
  <p>Note: P6 Update table is created with this code:</p>
  
  <pre><code>P6 Update = CALENDAR(MIN('Data for Pivot'[Date]), MAX('Data for Pivot'[Date]))
  </code></pre>