Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculation error SUMX in table

Hello all,     I want to create a measure to calculate the Current Ticket  based on the following code:   Current Ticket = var currentDate = MAX(OWK_CI_INCIDENTS[IDT_STARTDATUM].[Date]) return S...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi Anonymous,

    The error message display clearly that SUM evaluates to numbers or dates, but it can't work with type string. In your resouce table, the data type for REMEDYTICKET_NUMBER is Text, so it return the error. 

    I create sample table similar like yours, but the datatype is number, it works fine.



    Best regards,
    Angelia

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

The error message display clearly that SUM evaluates to numbers or dates, but it can't work with type string. In your resouce table, the data type for REMEDYTICKET_NUMBER is Text, so it return the error. 

I create sample table similar like yours, but the datatype is number, it works fine.



Best regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

hI v-huizhn-msft,

 

Thank you for testing. the REMEDY_TICKET was created as a Text. For example INC0000012345.

I had to split this column via Delimiter and removed the 'INC'.

 

Also i changed the SUMX into COUNTX , because i want to count how many remedy tickets have been created in the current year.

 

have a nice day.