title: MDX LastSibling of a Filtered Ancestor (Calculated Member)
body: <p>Within a Calculated Member in my cube I am leveraging the <code>Ancestor</code> function in combination with the <code>LastSibling</code> as in the below snipped:</p>
  
  <pre><code>Ancestor
  ( 
      [Dimension].[User Hierarchy].CurrentMember,
      [Dimension].[User Hierarchy].[Desired Member Level]
  ).LastSibling
  </code></pre>
  
  <p>Is it possible to Filter the set that contains the returned ancestor before pulling the <code>LastSibling</code>? For example of the ancestors returned by this, apply the following <code>Filter</code> expression:</p>
  
  <pre><code>Filter  
  (
      [Dimension].[User Hierarchy].[Is Actual].Members,
      [Dimension].[User Hierarchy].Properties( "Is Actual" ) = "N"            
  )
  </code></pre>
  
  <p>Ultimately I am attempting from my <code>CurrentMember</code> of the hierarchy, to return the last member of the same set that the of the member the <code>Ancestor</code> function returned, which satisfies the mentioned filter.</p>