Forum Discussion
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...
- HotChilli
Community Champion
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
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 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
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
