DAX Divide one Column by Another Column - Getting Error Msg

[lager1001]

Trying to divide the values in one column by the corresponding values in another column (in DAX) but I get the error message: " A single value for column cannot be determined". Each row has its own values. Why can I not simply divide one column by another? What is the work around?

 

[sandy666]

check if any value is a text
or are you trying divide by 0

 

[lager1001]

I was able to resolve this hours ago but can't remember how I did it. Been so busy with so many things. Thanks for your help. LOL.