Over- and underdensities are simply defined with respect to the mean density $\bar{\rho}$.
That is, if $\rho(x) > \bar{\rho}$, then $\delta(x)$ is positive and you call it an overdensity, whereas
if $\rho(x) < \bar{\rho}$, then $\delta(x)$ is negative and you call it an underdensity.
In other words, the threshold you're requesting is $\bar{\rho}$.
In cosmology, one is more often interested in the overdensities, because these are the ones that will evolve into the "most interesting" structures, i.e. galaxies, groups, filaments, sheets, and clusters. The underdensities will evolve into voids, which are of course interesting too.
But not as beautiful.