Issue with RANKX

[MarkEden]

Hi All,

I'm having an issue with RANKX on something that seems like it should be straight forward. I've tried various solutions found in forums but still can't resolve it.

I am creating a rank by insurer based on total premium in last 12 months, I have a rankx formula that works well in a table, however the total is incorrect. I need to add this total into a card as well so need to understand why.

The below table shows the difference for Insurer A. The rank 3 is correct for this insurer, however in the total it shows as 4. 4 is also the result when visualised in a card. I believe it is to do with the context of the total premium but can't figure out how to modify the RANKX measure to match the context of the table. 

Here is the current measure:

Insurer Rank Overall = 
    RANKX ( 
    ALL('Insurer Groups'[Insurer Group Report Name]),
    [LTM Premium])

And hear is the result

Any help is appreciated.

[rajulshah · Accepted solution]

Hello @MarkEden ,

If you want the sum of the rank, please plot the following measure:

Total Rank =
SUMX(VALUES('Insurer Groups'[Insurer Group Report Name]),[Insurer Rank Overall])

Let me know if this didn't work.

[MarkEden]

Works perfectly. Thanks for your help!