cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Expression error: The name 'sum' wasn't recognized. Make sure it's spelled correctly.

Hi

when i create a custon column with sum(if [column] ="" then "" else "")

i am getting the error.

Thanks,

Kishore

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator

## Re: Expression error: The name 'sum' wasn't recognized. Make sure it's spelled correctly.

If you create a calculated column use DAX, you can't write a expression in SUM( ) function. You can use the SUMX( ) function like below:

Column = SUMX('Table1',IF('Table1'[ID]="a",0,'Table1'[Amount]))

Column 2 = SUMX(FILTER('Table1','Table1'[ID]<>"a"),'Table1'[Amount])

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator

## Re: Expression error: The name 'sum' wasn't recognized. Make sure it's spelled correctly.

If you create a calculated column use DAX, you can't write a expression in SUM( ) function. You can use the SUMX( ) function like below:

Column = SUMX('Table1',IF('Table1'[ID]="a",0,'Table1'[Amount]))

Column 2 = SUMX(FILTER('Table1','Table1'[ID]<>"a"),'Table1'[Amount])

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User

## Re: Expression error: The name 'sum' wasn't recognized. Make sure it's spelled correctly.

use the below code it will help .

column = if( column=" A ", " B " , " C " )

if not let me know i will help u