RANKX

[Anonymous]

Hi Everyone,

I would like to ask for help. I would like to RANK the Total Forecasted Amount (Total MRC Only) per Sales Person, but I'm not sure why its not working when using the SUMx and RANKx.

First, I total the amount of TotalMRC then I use that measure to RANK the sales person. But the Rank Number is off.

I attached screenshots on this post.

THANK YOU SO MUCH IN ADVANCE.

Arvin

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Create a measure using DAX below.

NewRankMeasure = RANKX(ALLSELECTED(Opportunities),
    CALCULATE([TotalMRC],ALLEXCEPT(Opportunities,Opportunities[Sales Person])),,DESC,Dense)

Regards,
Lydia

[Zubair_Muhammad]

HI @Anonymous

Try replacing ALL (Opportunities)

with

ALLSELECTED(Opportunities[Sales Person])