title: DAX cannot compute a FILTER with "not equals" comparison
body: <p>I have a single column with 400K rows, which contain random numbers.</p>
  
  <p>The following DAX formula calculates immediately, but the inverse (just negating the equals condition) results in an Out Of Memory Exception (after the calculation runs for several minutes). Can you reproduce it and how to solve it? Thanks.</p>
  
  <pre><code>test_filter_1 = COUNTROWS(
      FILTER(
               table_1,
               table_1[column1] = EARLIER(table_1[column1])
       )
  )
  
  
  test_filter_1_negated = COUNTROWS(
             FILTER(
                     table_1,
                     NOT(table_1[column1] = EARLIER(table_1[column1]))
               )
    )
  </code></pre>