title: How to filter a measure based on another measure
body: <p>I have a dimension table called <code>DimUser</code> that has 1 row per user. I have a measure based on this dimension called "USER COUNT" which is count of rows of the DimUser table. I also have a calculated measure called "ACTIVE DAYS" which returns no of days a user is active.</p>
  
  <p>Now, I want to create another calculated measure based on this 2 measures, where I count only users who are active more than 5 days. I have total 5 users in my user table and 2 users in my fact table who are active more than 5 days. My <code>MDX</code> expression should return 2.</p>
  
  <p>This is what I wrote</p>
  
  <pre><code>FILTER([Measures].[USER COUNT], [Measures].[ACTIVE DAYS] &gt; 5)
  </code></pre>
  
  <p>But this gives me 5 as the answer instead of 2. What am I doing wrong?</p>
  
  <p>Next I tried this, but this fails compilation saying two measures in the expression are not allowed</p>
  
  <pre><code>([Measures].[USER COUNT], [Measures].[ACTIVE DAYS] &gt; 5)
  </code></pre>
  
  <p>Next, I tried creating a new calculated member called [IsActive] that returns true or false if active days > 5 and then use that as filter on the [Measures].[USER COUNT].</p>
  
  <p>How do I go about doing this?</p>