You want to make a throwing axe, and only stick the axe into the wall if it’s hit by the metal side?
That’s easy, in the Axe actor blueprint, just make a collision box for the metal head. Then for this collision box, apply a collision event (on event hit), which disables the physics for the whole mesh, thus making it stick in place.
At best, make the collision box only around the sharp knive part of the axe head.
This way, if the axe mesh hit’s the wall with the sharp head, it will stick. If it hits the wall with the wooden handle or the back of the axe knive-head, it will just bounce of the wall, as it should.
EDIT: You don’t need to assign any physics material at all.