Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

RankX is not Ranking correctly

The other solutions on this forum don't seem to work for some reason.  I must have a tricky one or something.   I have a table that has PointsForRank, as you can see that I want to rank over by eac...
Need Help
  • mickey64's avatar
    mickey64
    1 year ago

    For your reference.

     

    Step 0: I use these DATA.

     

    Step 1: I correct the formula.

    Rank =
    RANKX(
    ALLSELECTED('Charge Off Collections'),
    CALCULATE(
    SUM('Charge Off Collections'[PointsForRank]),
    ALLEXCEPT('Charge Off Collections','Charge Off Collections'[Operator Name], 'Charge Off Collections'[Team Name])
    ),
    ,
    desc,
    Dense)

     

    Step 2: I make a ’Table’.

     

mickey64's avatar
mickey64
Super User
1 year ago

For your reference.

 

Step 0: I use these DATA.

 

Step 1: I correct the formula.

Rank =
RANKX(
ALLSELECTED('Charge Off Collections'),
CALCULATE(
SUM('Charge Off Collections'[PointsForRank]),
ALLEXCEPT('Charge Off Collections','Charge Off Collections'[Operator Name], 'Charge Off Collections'[Team Name])
),
,
desc,
Dense)

 

Step 2: I make a ’Table’.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

So I did create a PointsforRank column in the dataset, and the rank works with that.  PBI doesn't like using measures in the calculate field in rankx for some reason.  Tyvm!