title: OLAP Tools - Excel - Calculated Measure - simple 'sum' function
body: <p>I have a very simple question.</p>
  <p>I am unfortunately a complete newbie in the field of MDX. I would like to check if a condition is met using a calculated measure. For this I use the following MDX statement via OLAP tools in Excel:</p>
  <p>IIF([Measures].[Target]&gt;0,1,NULL)</p>
  <p><a href="https://i.stack.imgur.com/yL2HM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yL2HM.png" alt="enter image description here" /></a></p>
  <p>Thereby I get a correct display on row level, but not in the total result. There I expect a 17 instead of the 1. Surely the Sum function is missing there, but I have no idea how to apply it.</p>
  <p>I would be very happy about any help. Thanks and greetings.</p>