You need to provide the Tail function with a set - you have provided the current member which is just one value ie a set with one value

So Tail(CurrentMember,3) = CurrentMember.

An example I use in my cubes (to get the latest year with revenue)

TAIL(NONEMPTY({[Date].[Year].Children},{[Measures].[Net Revenue]}),1);

Mack