Ranking ties

[Shab]

The Rank function specifies an optional 3rd parameter for tied ranking. If you specify this parameter, the ranking ignores the sort order of the set (even if you sorted it before) and it sorts the set in descending order based on the third parameter value. Ties get the same rank but the next one skips 1 number. For example you get 1, 2, 2 and 4.

Here are two questions:

Can you use this method and have the set sorted in descending order based on the values of the third parameter?

Is there a way to turn off the skipping of the numbers in ranking so that you get 1,2,2,3?

Thanks,

 

[Shab]

I found the answer to one of the questions I had. In order to get ranking with ties to sort the set in Ascending order, all you have to do is to specify the negative of the third paramter:

For example Rank( Deimension.Currentmember,
YourSet,
- [Measures].[Sales])