Percent Complete between 2 columns - Underlying data is Text

https://community.powerbi.com/t5/Desktop/Percent-between-2-columns/td-p/410062

The idea is the same as the oringal thread however the underlying data is text and this is represented in PBI as a count

Example would be: Water Target (underlying data is a COUNT of text values relating to each LOC code)

The DAX code posted looks like it would work but when I use that, the error I recieve is, "Can't divide Text Value"

Thanks!

Dom