title: MDX - SSAS - HOW TO SUM THE FACT MEASURE FOR ALL AGE GROUPS AT CERTAIN CASUALTY TYPE IN EACH YEAR?
body: <p>I'm having a task to
  <a href="https://i.stack.imgur.com/1npeA.png" rel="nofollow noreferrer">use MDX to execute the query for my cube so that the final result can be like the image</a>.
  My problem is that I cannot use MDX to <strong>count the number of casualties for all age group at the certain casualty type in each year</strong> (the column which has the red line around) and <strong>give the average number of casualties happens from a range of year (for example: 2011 - 2014) for each age group at the certain casualty type</strong> (the column which has the orange line around).</p>
  <p>All I can do now is return the result <a href="https://i.stack.imgur.com/cPaSj.png" rel="nofollow noreferrer">report the number of casualties by </a> by using the code</p>
  <pre><code>SELECT non empty [Dim Date Ques 3].[Ques3_Calendar].[Year] on columns, 
  non empty crossjoin ([Dim Casualty Type Ques 3].[Description_CasualtyType].[Description_CasualtyType],[Dim Age Band Ques 3].[Description_AgeBand].[Description_AgeBand]) on rows
  FROM [MyBI DDS]
  WHERE [Dim Gender Ques 3].[Description_Sex].&amp;[Female]
  </code></pre>
  <p>P.s: <a href="https://i.stack.imgur.com/tnt6j.png" rel="nofollow noreferrer">You guys can also check my cube </a>
  Please help me to fix it :( Thank you so much. I have been searching several times but it doesn't make sense.</p>