Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Error: The function SUM can not work with values of type String

Hi All,

 

I am trying to create a measure but i encountered error when trying to put this on the values of a visualization. I need to measure the metric "A2R GPI 4" then sum the client on it. Please help me to correct my syntax, thanks. 

 

GPI 4 = IF(SUM('Source Dump'[Metric]) = "A2R GPI 4", SUM('Source Dump'[Client]

ERROR:

 

 

Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    Already fix my problem.

     

    I created this formula 

    GPI 4 = SUMX(FILTER('Source Dump','Source Dump'[Metric]="A2R GPI 4"),'Source Dump'[Client])

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Already fix my problem.

     

    I created this formula 

    GPI 4 = SUMX(FILTER('Source Dump','Source Dump'[Metric]="A2R GPI 4"),'Source Dump'[Client])