topic RANKX ignoring Order and Ties in DAX Commands and Tips

RANKX ignoring Order and Ties

edwardburton — Thu, 09 Dec 2021 10:53:57 GMT

Hello

I've used this piece of code from the answer linked almost exactly.

SumPointsRank = 
Var summry=SUMMARIZE(ALLSELECTED(Results),[Player],"Sum",SUM(Results[Points]))
var tmp=ADDCOLUMNS(summry,"RNK",RANKX(summry,[Sum],,DESC,Dense))
return
MAXX(FILTER(tmp,[Player]=SELECTEDVALUE(Results[Player])),[RNK])

Solved: Ranking a measure - Microsoft Power BI Community

The problem I'm having is that it appears to be stuck at ASC and Dense no matter what I enter there. I'd like it to be DESC and Skip, but it just ignores those commands and uses ASC and Dense almost as a default.

Is this a problem anyone else has seen and knows how to fix?

Re: RANKX ignoring Order and Ties

amitchandak — Thu, 09 Dec 2021 11:49:31 GMT

edwardburton , what is the expected output

Try like

RANKX(allselected(Results[Player]),calculate(SUM(Results[Points])),,DESC,skip)

Can you share sample data and sample output in table format?

Re: RANKX ignoring Order and Ties

v-angzheng-msft — Wed, 15 Dec 2021 02:40:04 GMT

Hi, edwardburton

Try the second measure

Measure2=
RANKX(ALLSELECTED(Results),CALCULATE(SUM(Results[Points]),ALLEXCEPT(Results,Results[Player])),,DESC,Dense)

If this doesn't work, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate measure.

Best Regards,
Community Support Team _ Zeon Zheng

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