If you're a member of some service, like a gym, video rental service, etc. and you want to stop being a member, you have to "cancel your membership".

You can also use the phrase "cancel (one's subscription)" for subscription services like magazines or web applications, and "cancel (one's) account" for bank accounts, investment accounts, and so on.