Well Anayo, I believe music is in a category of its own. It's very related to ambient noise, but will vary a lot depending on the kind of music and your own personality.
When I work in open-spaces, I find myself barely able to focus without music, because it's a good way to cut that ambient noise. But I am very picky about which music I listen to when I'm in work/focus timespans. And I am very easily distracted by humans voices. People talking in other rooms can get me out of focus (you can imagine how much I think open space offices are an aberration). So I need some music to be able to focus, but I do take great care: no lyrics ever, not too quiet nor not too energic to just be good at that ambient-noise-shutter role.
People which are distracted by music could use noise/drone sound generators though, to achieve the same effect (but I find it very boring and even tiring after a few hours... but that's just personal taste)
This has already been shared in other thread, but over the time I gathered a few playlists, 2 of them are public, whenever I need to focus at work. Obviously, everyone's experience is different, but it could help getting started. (And I like to have those playlist, so that as soon as some noise/distraction shows up in the office, I can just it play and not have to think or search for something to listen.... which would be switching from one distraction to another)
Here's the 'quiet' playlist (soundtracks, cello, compositional ambient, drone, minimal music...) more than 68 hours as of today with more than 900 titles, playing it random should do the job) open.spotify.com/user/sebportebois/playlist/3eKkI…
And here's my jazz-at-work one, more energic, obviously more subject to personal taste (but when there's more ambient noise, it does a better job at shutting down these external distractions) open.spotify.com/user/sebportebois/playlist/13FYC…
And when there's really too much noise, I sometimes switch to Meshuggah (yes, I'm able to work with this, and it even sometimes help me focus and remove all the anger after hearing too much stupid things from CEOs ;D ... but it's exhausting music and I'm not able to listen to that for too long =)