Search code examples
sqlvisual-studiossasmdxcube

MDX SUM function returning true

I am trying to do a simple sum of 2 measures in MDX.

my query looks like this 

[Measures].[Submissions Count] = SUM({[Measures].[Gain Count] , [Measures].[No Movement Count]}, [Measures].[Submissions Count])

when i brows the cube in visual studio the result displays 'True'. It should be a numeric value

Solution

  • Can you not just use the + operator?

    [Measures].[Submissions Count] = 
  [Measures].[Gain Count] + [Measures].[No Movement Count];