Set $\dfrac p{1-p}=b$ and write
$$y=\sum_{i=0}^x\binom aib^i=\sum_{i=0}^x\binom ai\frac{p^i}{(1-p)^i}=\frac 1{(1-p)^a}\sum_{i=0}^x\binom ai p^i(1-p)^{a-i}.$$
Then $y$ is a scaled cumulative binomial distribution, which can be denoted $(1-p)^aF(x;n,p)$.
The inverse can be expressed as
$$x=F^{-1}\left(\frac y{(1-p)^a};n,p\right)$$ and there is no explicit formula.
* * *
If what you are after is a computation algorithm (which I suspect), a possible way is to precompute and store the partial sums up to the maximum $x$ and answer queries by dichotomic search.