title: MDX query to count number of product names
body: <p>I am new to MDX and trying to count number of product names on a week basis. I have written the below MDX query, but I get all product count as a result.</p>
  
  <pre><code>WITH MEMBER [Measures].[Count Of Members] AS
  Count(Existing [Product Dimension].[ProductName].Members)
  
  SELECT {[Measures].[Count Of Members]} ON 0,  
  NON EMPTY
  {
  [Date Dimension].[Financial WC]
  } ON 1
  
  FROM [Cube]
  WHERE ([Date Dimension].[FinancialYear].&amp;[2018/19],
         [Sales].[PaymentType].&amp;[Delivery])
  </code></pre>
  
  <p>I am getting result as :</p>
  
  <p>"All 230" </p>
  
  <p>as there are total 230 product names</p>
  
  <p>But I want the result as:</p>
  
  <p>week1 50
  week2 73
  week3 34
  .
  . </p>