title: DAX - filtering out whole row from data table that meets certain condition(s)
body: <p>I have a table like following:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true">
  <div class="snippet-code">
  <pre class="snippet-code-html lang-html prettyprint-override"><code>&lt;style type="text/css"&gt;
  .tg  {border-collapse:collapse;border-spacing:0;}
  .tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
  .tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
  .tg .tg-baqh{text-align:center;vertical-align:top}
  &lt;/style&gt;
  &lt;table class="tg"&gt;
    &lt;tr&gt;
      &lt;th class="tg-baqh"&gt;Store Name&lt;/th&gt;
      &lt;th class="tg-baqh"&gt;Week Number&lt;/th&gt;
      &lt;th class="tg-baqh"&gt;Sales&lt;/th&gt;
      &lt;th class="tg-baqh"&gt;Sales-LY&lt;/th&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store A&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;1&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;20&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;15&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store A&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;2&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;25&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;20&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store A&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;3&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;30&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;25&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store B&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;1&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;15&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;10&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store B&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;2&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;15&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;15&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store B&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;3&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;20&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;15&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store C&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;1&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;30&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;25&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store C&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;2&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;0&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;20&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr&gt;
      &lt;td class="tg-baqh"&gt;Store C&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;3&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;25&lt;/td&gt;
      &lt;td class="tg-baqh"&gt;20&lt;/td&gt;
    &lt;/tr&gt;
  &lt;/table&gt;</code></pre>
  </div>
  </div>
  </p>
  
  <p>I would like to return (lets' say) a pivot table with </p>
  
  <p>Salex IDX = SUM(Sales)/SUM(Sales-LY) as a measure, ignoring the data points for "Week 2 for Store C".
  So it's not a filter on just Week Number or Store, but its a filter on specific row(s) identified by multiple parameters.</p>
  
  <p>Essentially, i would like to get 'like for like' results, excluding any weeks where Sales or Sales-LY columns are zero(or null)</p>
  
  <p>Any ideas?</p>