The chances are you don't need a new cable drum.
The most likely and common answer is a break in the cord.
When you pull the cord out and use the machine, everyone wants it to go another 6 inches, so it gets pulled along by the cable. Over time the strands of the cable break and make it intermittent.
The plastic coating stays in tact because it has a bit of stretch in it, the copper conducters inside just break.
Pull the cable of the drum, make sure not to release the drum spring mechanism.
Release the cable from the drum, noting th routing of the cable.
Pull hard on one wire at a time. One will almost certainly pull out. Normally about 7 inches from the end.
Re terminate the cable, re wind by releasing the spring mechanism and refit to vacuum.
This can also happen on the plug end, but you said it was associated to the machine end, so much more likely its at this end
I hope this answers your question and you click the accept button for me, as this is how I get paid for helping you.