undefinedhe function SUMX cannot work with values of type String

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.