Weird transparency sorting issue

[MarcoMariaRossi]

I found out a way to fix this in the end.
If you are having a similar issue click on the mesh and find the “Translucency Sort Priority” attribute and play with it. It should do the trick !