title: DAX SUM with Two Filter and Ignore negative value
body: <pre><code>AR Outstanding = 
  CALCULATE(
      SUM(Invoices[Customer Invoice]),
      FILTER(
          Invoices, 
          Invoices[Invoice Status]=0
      ),
      FILTER(
          Invoices, 
          Invoices[Customer Invoice]&gt;1
      )
  )
  </code></pre>
  <ol>
  <li><p>Filter = Invoice Status 0 means “UNPAID”</p>
  </li>
  <li><p>Filter = Customer Invoice &gt;1 Any invoice greater that $1.00 dollars, so meaning ignore any negative value.</p>
  </li>
  </ol>
  <p>Example: =SUMIF(A2:A89,&quot;&gt;1&quot;) Calculation in Excel work, not in DAX.</p>
  <p>The formula work well overall, except decimal value. Is not calculating any decimal.</p>
  <p>Any suggestion?</p>