title: How should I write an MDX Filter statement with multiple OR conditions efficiently?
body: <p>In SQL you can compare a field against a set in the form</p>
  
  <pre><code>[Foo] In {"Bar1", "Bar2", ... , "BarN"}
  </code></pre>
  
  <p>However I'm having trouble working out how to move a filter expression into something like this. That is, for now, I end up with:</p>
  
  <pre><code>Filter(
      [MyHierarchy].[Foo].Members,
      [MyHierarchy].CurentMember.Name = "1"
      OR [MyHierarchy].CurentMember.Name = "2"
      ...
      OR [MyHierarchy].CurentMember.Name = "N"
  )
  </code></pre>
  
  <p>Since I have 20-30 comparisons, and a moderate chance of the heirarchy name changing, I'd much rather maintain a set and a hierarchy name than a long expression. Is there any way to accomplish this?</p>
  
  <p>Worth bearing in mind that the context is an Excel CubeSet function, so I'm a little limited in terms of defining my own members in the WITH clause.</p>