Forum Discussion
mmossman
3 years agoFrequent Visitor
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 i...
Anonymous
3 years agoNot applicable
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
3 years agoFrequent Visitor
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.