Forum Discussion

mmossman's avatar
mmossman
Frequent Visitor
3 years ago

RANX Values Don't Match Table

I'm working on a PBI Dashboard for a fantasy football league. One thing that I wanted to show were the Top 3 & Bottom 3 performances by position (QB in my attached sample). Our league has 12 people in it so I would expect to see rankings from 1-12. However, what I am getting is rankings from 1-192. What appears to be happening is each QB is being associated to each player in the league. Where am I going wrong?

Sample File

 

My rank formula is:

 

Performance Rank = 
RANKX(
    ALL(Points)
    , [Performance]
    ,, DESC
)

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi mmossman ,

     

    Like this?

    Just change your measure:

    Performance Rank = RANKX(FILTER(ALL(Points),'Points'[Position]="QB"),[Performance],,DESC)

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

    • mmossman's avatar
      mmossman
      Frequent Visitor
      3 years ago

      Ah. So I need to have a different rank calc per position? I was hoping for something that would be more "flexible". I guess there are only 6 positions so it could be worse.