title: MDX - set member by another member values
body: <p>I have this table generated with MDX.
  <br><br>
      <a href="http://i62.tinypic.com/2m5xeg0.jpg" rel="nofollow">http://i62.tinypic.com/2m5xeg0.jpg</a>
  <br/><br>
  I need to create a calculated dimension (or a measure) called "this year" with 2 values:<br>
    YES: if currentmember YEAR includes value 2015 and <br>
    NO: if member YEAR does not include 2015 for every CLIENT ID <br><br>
     <a href="http://i57.tinypic.com/2h508yx.jpg" rel="nofollow">http://i57.tinypic.com/2h508yx.jpg</a> <br><br>
  The MDX code is: <br></p>
  
  <pre>
  SELECT
      NON EMPTY {[Measures].[QUANTITY]} ON COLUMNS,
      NON EMPTY CrossJoin({CLIENT ID].[CLIENT ID].Members, {[YEAR].[YEAR].Members}) ON ROWS
  FROM
      [MyCube]
  </pre>