Is there ever a case where a function can be derived implicitly and explicitly ?

sure, assuming you mean "differentiated" ...

y = x^2 - 5
y' = 2x

x^2 - y = 5
2x - y' = 0