RANKING ADDING 1 TO VALUE

[ViralPatel212]

Hi Team,

Wondering if you could help. 

I am trying to create a simple summarized table where it shows where Barclays sits for each category.

in my main table the ranking works using this formula. I have filtered the category to NNIP and it shows that Barclays is ranked 2 based of Vol. (MM).

Ranking: IF( [Ranking Size (Vol)] = blank(), BLANK(), RANKX(ALLSELECTED('Dealer Ranking'[Counter Party]),[Ranking Size (Vol)],,DESC))

However when i table showing jus category and the rank it doesn't work.

In this on the allselected didnt work so i tried:  

Dealer Ranking 4 = RANKX(ALL('Dealer Ranking'[Counter Party]),[Ranking Size (Vol)],,DESC) 

as you can see i have put a visual filter to show Barclays but im getting 3 rather than 2?

Hope this make sense.

thanks

viral

[ViralPatel212 · Accepted solution]

Resolved the issue: 

created a measure:

Measure:
var _rank = RANKX(ALL('Dealer Ranking'[Counter Party]),[Ranking Size (Vol)],,DESC)
VAR _tab =
    FILTER (
        ADDCOLUMNS (
            ALL( 'Dealer Ranking'[Counter Party] ),
            "@rank", [Dealer Ranking Number 2 test]
        ),
        [Counter Party] = "Barclays"
    )
VAR _rankbarclays =
 ( MAXX ( _tab, [@rank] )
RETURN

_rankbarclays

[ViralPatel212]

@amitchandak any chance of you looking into this?

[amitchandak]

@ViralPatel212 , Try new new function in the measure

RANK ( desc, ALLSELECTED('Dealer Ranking'[Counter Party]), orderBy([Ranking Size (Vol)]), LAST )

[ViralPatel212]

@amitchandak 

i think you have given the wrong measure here? i tried that and i get a error: 

The value for RANK's Ties parameter is invalid. The admissble values are: SKIP, DENSE.