Francesca,
I'd use "hopeless at". Of course, it's not an idiom, which is what I believe Pucca was looking for.
"washout" and "dead loss" are more like idioms, but I don't use those
expressions in the context of being bad at something. I don't
think I use "washout" at all. I use "It was...