Search code examples
mdxbusiness-intelligenceolap-cube

Calcuatated Measure Not working against some dimensions

I have a calculated measure whose code is:

   COUNT(
   NONEMPTY(
   NONEMPTY(
   [Customer].[CustomerID].[CustomerID]
   , [Measures].[Enrolled Customers])
   , {[Measures].[Sales]}
   )
   )

It calaulates the count of customers who are enrolled and are active(i.e buys something). It perfectly works against Date dimension but not against Customer Dimension.It shows the same aggregated value for all members when i drag it to excel.

My Customer Dimension has CustomerID(properly linked to fact table), City, Country/Region Code, StateProvince Code, Geography(Hierarchy)

Any help would be appreciated.

Solution

  • Try add existing keyword:

    COUNT(
NONEMPTY(
NONEMPTY(
 existing [Customer].[CustomerID].[CustomerID]
, [Measures].[Enrolled Customers])
, {[Measures].[Sales]}
)
)