title: MDX: Filter a member that doesn't exist?
body: <p>I'm new to MDX, so I assume this is a newbie question.</p>
  
  <p><strong>Existing dimension:</strong> status
  <strong>Existing Measure:</strong> count</p>
  
  <p><strong>Existing Query:</strong></p>
  
  <pre><code>SELECT 
    NON EMPTY [status].CHILDREN ON 0,
    NON EMPTY Measures.count ON 1
  FROM [objects]
  </code></pre>
  
  <p>I want count the records with status='C'. But sometimes, there're no records that match that criteria. So if I do:</p>
  
  <pre><code>SELECT 
    NON EMPTY [status].[C] ON 0,
    NON EMPTY Measures.count ON 1
  FROM [objects]
  </code></pre>
  
  <p>I get this error:</p>
  
  <pre><code>*MDX object '[status].[C]' not found in cube 'objects'*
  </code></pre>
  
  <p>I would like a query that returns 0 in that case. Which is the right way to do that query?</p>
  
  <p>Thanks!</p>