title: Excel MDX - Count of dates selected in slicer
body: <p>I'm using Excel to connect to an OLAP cube and building a report to show actual hours charged to a project. I need to create a measure now to perform some calculation on the actual hours for which I need to get the number of days that the user is filtering on. The date range is added as a slicer. Is there a way to do this? I've tried </p>
  
  <p>Count(Existing [Work Item].[System_CreatedDate].members)</p>
  
  <p>But this returns all created dates in the entire data set. I only need a count of the ones the user has filtered on. Right now it should return 66 or so since I've set it to 1/1/2014 to 3/7/2014 but I'm getting back 503 which is how many members there are in total in the OLAP cube not taking into account any filters I have set.</p>
  
  <p>My apologies for the basic question and the inadequate explanation of what I'm trying to get to. I have very limited experience with MDX and measures / members. I hope the question is clear enough.</p>
  
  <p>Help will be truly appreciated.</p>
  
  <p>Thanks.</p>