CUBEMEMBER dynamic caption

Hey all, this is my first post so I hope to manage and make a valid and well defined post, if not please give me some feedback.

I am trying to change the caption displayed in a cell containing a CUBEMEMBER function. I know that I can hardtype any name using " ", or reference another cell, but what I need is to pick a name from another column of the same table.

Here is the formula:

Please Login or Register  to view this content.

I would like to choose a name coming from the same row but a different column of my table D_DIM_MEASURES, let's say the column [NAME].

I am trying the following but without success:

Please Login or Register  to view this content.

Any help much appreciated.

You could embed a CUBEMEMBER function in the caption argument, but what name would you be pulling back?