I'm hoping to add a calculation to my SSAS Cube (SSAS 2012) that will show the relative rank of whatever the current member is against all other members in that grouper, without specifying the groupers in advance.
For example, say I have a calculation already for
Efficiency which is defined as $$/hour.
I would like to add an
Efficiency Rank calculation as well that will tell me what relative position the current member has in it's set.
The Syntax I tried was
Which I realize is incorrect.
I can't seem to locate a guide to this anywhere else, so I'm hoping there is some established best practice or pattern for this since it seems like it would be a relatively common business requirement.