Calculating a dynamic benchmark with multiple conditions

Hi all, I am struggling with a problem and I hope you can help.  My star schema looks like this: fact sales, dim product, dim country, dim store I am trying to achieve the following (mind ...