title: Sum an IIF in MDX
body: <p>Is it possible to sum an IIF statment in MDX?</p>
  
  <p>Here's an example of what I am trying to do:</p>
  
  <pre><code>With
  Member [dim something].[group].[Summed] as
  Sum(
  iif( [dim something].[date one] = [dim date].[specific date],1,0)
     )
  
  Select  [dim something].[group].[summed] on 0,
          [dim date].[specific date].members on 1
  
  From    [Cube]
  </code></pre>
  
  <p>I know this does not work, just trying to show what I am trying to do. I want to evaluate a condition and return a 1 or zero based on that condition. Then sum or count the number of times it was returned as 1</p>
  
  <p>Fairly new to MDX, coming from a SQL background it's very different.</p>