Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

undefinedhe function SUMX cannot work with values of type String

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 

 

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    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.

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    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.