I think basically, it's only gonna fire 2 backstabs if you didn't do too much damage on the first one, or more accurately, take away too high a % of hit points from the target.

When I had an imperial thief and fought mostly sanc'd paladins, despoiled scions, and resisting ragers, I really kinda wished I had it.