Report Portal

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...

 

Tags: mdx, rank

 

2007-2015 VidasSoft Systems Inc.