title: SSAS: Get a distinct Count based on two different elements
body: <p>I need to create a distinct count of people who fall into two different dimensions.</p>
  
  <p>One is called [Student Research Degree].[Is Research Degree Current].&amp;[Yes]
  The other is called [Student Research Degree].[Is Research Degree Complete].&amp;[Yes]</p>
  
  <p>If one or the other are Yes, or both, then I need to count the record.
  If both are no, I can exclude it.  I have a row counter measure called [Measures].[Student ID Distinct Count Hidden] already in place.</p>
  
  <p>If I use just one element with the measure, I get the right answer, but if I try to cross join the other elements, I get a result of NULL.</p>
  
  <p>eg</p>
  
  <pre><code>AGGREGATE(CROSSJOIN(
      [Student Research Degree].[Is Research Degree Current].&amp;[Yes] 
          ,[Student Research Degree].[Is Research Degree Complete].&amp;[Yes]
  ), [Measures].[Student ID Distinct Count Hidden])
  </code></pre>
  
  <p>I am aware that I can just land an extra value in the ETL, and have SQL do the work, and in the end this might be the solution.  Is there a way of doing an OR statement on this sort of thing?</p>