Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SUM Text and Numeric

Hi,   Wondering if you can help.    I have data which looks like the following, below dummy data   Name Of Appeal Code Volume Status TV FIN 10 Success Media FIN 5 Failed Pr...
Need Help
HotChilli's avatar
HotChilli
Community Champion
7 years ago

The pattern to use is

Measure = SUMX(FILTER(Table2, Table2[Code] = "FIN") , VALUE(Table2[Volume]) )

so you're using VALUE for each row in your filtered table.

I'll let you add the 'success' part

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I had something similar before & have the same problem. The visual cannot be displayed and the error is because the VALUE function cannot convert the string 'OK' in the colum called Volume.

 

Cannot convert value 'OK' of type Text to type Number

 

HotChilli 

HotChilli wrote:

The pattern to use is

Measure = SUMX(FILTER(Table2, Table2[Code] = "FIN") , VALUE(Table2[Volume]) )

so you're using VALUE for each row in your filtered table.

I'll let you add the 'success' part

 

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    You need to debug it at your side.  I used your data (thanks for providing this, many people don't)

    If you link your pbix, I'll have a look

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

      The data was an example as I'm working personal identifiable data. I'll debug and explore. 

       

      Thanks for your speed reply. 

      HotChilli wrote:

      You need to debug it at your side.  I used your data (thanks for providing this, many people don't)

      If you link your pbix, I'll have a look