title: Calculated measure MDX through Pivot Table Excel
body: <p>I am connected to OLAP cube, I created a pivottable. </p>
  
  <p>I would like to know if with the OLAP tool of excel is possible to calculate the number of distinct invoice number taking acount the current filters like year, country and region of the pivot table ?</p>
  
  <p>I tried with Countdistinct it gives me the same result for each country.
  DistinctCount([PO TYPE].[PO NUMBER].[PO NUMBER])</p>