Goldfish Rank
Few months ago, while on vacation, I saw an interesting post on MSDN forum where a user asked for rank of members placed on rows, irrespective of hierarchy. Furthermore, that was supposed to be achieved using only one calculated measure, nothing else.
Intrigued by this puzzle, I made an example of such calculated measure on Adventure Works database using Axis() function. Here it is:
Read more...