MDX Compare or Rank Similar Members

MDX makes it very easy for us to compare one member against others, using functions such as RANK() etc. But how do we dynamically compare a member against a subset of other members? I came across a customer requirement recently where we had to rank a member against other members that had similar properties, based on other measures. This will probably make more sense with an example. Taking AdventureWorks, we can easily calculate the sales rank of each product using something like this: