Error Reading Meaning?

Hi  W2SANC ,

According to the error message: In your measure[specific values], the SumX() function was used to perform an aggregation operation on string-formatted data resulting in the error.

Generally speaking, SumX() will perform aggregation operations on numeric format data, if you want the public announcement to take effect, you may consider changing the string format data to numeric type, or if you want to perform calculations on the string format data, you can use the MaxX () function or Minx() function, these two functions to see the maximum and minimum value of the text/numeric data type.

SUMX function (DAX) - DAX | Microsoft Learn

MAXX function (DAX) - DAX | Microsoft Learn

MINX function (DAX) - DAX | Microsoft Learn

Or use the Value() function in the formula to change the string to a numeric value:

VALUE function (DAX) - DAX | Microsoft Learn

This is the related document, you can view this content:

Solved: Using Measures: The function SUM cannot work with ... - Microsoft Fabric Community

Solved: The function SUMX cannot work with values of type ... - Microsoft Fabric Community

powerbi - The function SUM cannot work with value of type string Power BI - Stack Overflow

Best Regards,

Liu Yang

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