Calculated measure MDX through Pivot Table Excel

Question

I am connected to OLAP cube, I created a pivottable.

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 ?

I tried with Countdistinct it gives me the same result for each country. DistinctCount([PO TYPE].[PO NUMBER].[PO NUMBER])

whytheq whytheq · Accepted Answer · 2014-12-30T21:58:34

Try using COUNT instead:

Count(
   Exists(
     [PO TYPE].[PO NUMBER].[PO NUMBER].MEMBERS,
     [Geography].[Country].CURRENTMEMBER,
     "MeasureGroupName"
   )
 )

You need to replace "MeasureGroupName" with a measure group name in your cube

Calculated measure MDX through Pivot Table Excel

1 Answers