undefinedhe function SUMX cannot work with values of type String

[moeconsult]

I need help fixing this error please, I am not summing any strings

Error Message:
MdxScript(Model) (8, 274) Calculation error in measure 'Sheet5'[Total Cost]: The function SUMX cannot work with values of type String. Attached file has all my formulas

Please see link to Pbfile here 

[v-lionel-msft · Accepted solution]

Hi @moeconsult ,

Modify the measure like this:

Total Cost = 
VAR x = [Course Duration]*([Facilitator Fee]+[Venue Fee]+[Facilitator Fee])
RETURN
IF(
    HASONEVALUE('Sheet5'[StartDate]),
    x,
    SUMX(
        SUMMARIZE(
            'Sheet5',
            'Sheet5'[StartDate],'Sheet5'[CourseName],
            "ABCD", x
        ),
        [ABCD]
    )
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Check data Type. Seems like it is text. Try to change it to number