title: MDX Filter by Members
body: <p>This is more of a general MDX question.  I want to filter those dates from the reporting date.fiscal hierarcy.  I was previously using a calculated member but I just put it in the query, it doesnt return any results.  </p>
  
  <pre><code>    SELECT 
                 { 
                  FILTER (
                           [Reporting Date].[Fiscal].MEMBERS
                          ,[Reporting Date].[Fiscal].currentmember &gt; [Reporting Date].[Fiscal].[Date].&amp;[2013-03-06]
                           AND
                           [Reporting Date].[Fiscal].currentmember &lt; [Reporting Date].[Fiscal].[Date].&amp;[2013-03-11]
                         )
  
                 }   on 1
                , 
                 {
                    Measures.Gross
                 } on 0
      FROM [Revenue]
  </code></pre>