title: Tableau: creating calculated field based on cell values
body: <p>Say I have the following worksheet table (the measure is an aggregate sum):</p>
  
  <pre><code>    Code    A   B
       123        10
       456    20  30
       789    40  
  </code></pre>
  
  <p>I'd like to create a calculated field (dimension) that I could use to filter out both the first and third row, in other words, keep only that record where A and B are both positive for the given Code. I've tried <code>IF/ELSE</code> with sum(measure) > 0 in the conditions but apparently I can't mix measures and aggregates. Thanks for any pointers.</p>