title: Filtering a Measure (or Removing Outliers)
body: <p>Say I have a measure, <code>foo</code>, in a cube, and I have a reporting requirement that users want to see the following measures in a report:</p>
  
  <pre><code>total foo
  total foo excluding instances where foo &gt; 10
  total foo excluding instances where foo &gt; 30
  </code></pre>
  
  <p>What is the best way to handle this?
  In the past, I have added Named Calculations which return <code>NULL</code> if <code>foo &gt; 10</code> or just <code>foo</code> otherwise.
  I feel like there has to be a way to accomplish this in MDX (something like <code>Filter([Measures].[foo], [Measures].[foo] &gt; 10))</code>, but I can't for the life of me figure anything out.</p>
  
  <p>Any ideas?</p>