Sum Function Error

Category: sql server analysisservices


Mike4100 on Wed, 06 Dec 2017 14:59:11

Here is my defined measure:  


MEASURE'Application'[Sum True Apps] = SUM([Num True Apps])  


Here is the error I keep getting and don't know why.

Parsing the query ...

Query (3, 44) Calculation error in measure 'Application'[Sum True Apps]: The SUM function only accepts a column reference as the argument number 1.

Parsing complete


Darren Gosbell on Wed, 06 Dec 2017 21:36:58

The most likely reason is that [Num True Apps] is another measure and like the error message says, you need to pass a column reference to the SUM() function

willson yuan on Thu, 07 Dec 2017 01:56:54

Hi Mike4100,

Thanks for your question.

If [Num True Apps] is indeed a column in table 'Application' , you may try below code:

MEASURE 'Application'[Sum True Apps] = SUM('Application'[Num True Apps])  
Your formula