title: MDX Calculated member with filter
body: <p>Being pretty new to MDX so this might be a rookie question. But have not been able to "translate" any answers to a solution!</p>
  
  <p>I have a Measure which Counts my number of rows called [Measures].[Fact Count]</p>
  
  <p>I also have a Dimension called [Document] which has a field called [Is Completed].</p>
  
  <p>The [Document].[Is Completed] can have one of two values: [Yes] or [No].</p>
  
  <p>The [Document] dimension does have several other fields, like [Document Type]</p>
  
  <p>What I would like to ask a question like "How big a percentage of my different document types have been completed".</p>
  
  <p>I have tried making a [Completed Count] like this:</p>
  
  <pre><code>([Measures].[Fact Count],
  [Document].[Is Completed].&amp;[Yes])
  </code></pre>
  
  <p>and then use it like:</p>
  
  <pre><code>[Measures].[Completed Count]/[Measures].[Fact Count]*100
  </code></pre>
  
  <p>But (of course) the [Completed Count] then takes all my completed documents instead of only those per e.g. [Document Type]</p>
  
  <p>Hope this makes sense to someone!</p>