title: Checking Multiple condition in case statement using MDX query
body: <p>How to write the below case statement in mdx.I moved the below mentioned columns in the fact table.</p>
  
  <pre><code>   sum(case when IsSummary = 1 and IsAudited  = 1 and FinalAuditFlag = 1 then 1 
  else 0 end) AuditsCompleted,--Count - Completed Audits
  </code></pre>
  
  <p>i tried the below MDX query. </p>
  
  <pre><code>WITH 
  
      MEMBER [Measures].[count]
      AS
      (
       case  ([Measures].currentmember )
              when 0 then ([Measures].[Is Summary] )
                      else 1 
              end 
          )
      Select 
              {[Measures].[count]}    on 0,
              [Dim_table1].[TableId].members  on 1
      from    [Dsv]   
  </code></pre>