Forum Discussion

DeanUW's avatar
DeanUW
Icon for Helper I rankHelper I
4 years ago
Solved

RankX Dense

I am trying to rank sales people based on YTD revenue total. When I rank the brokers based on the broker name column the rank repeats/starts over multiple times randomly.  If I rank everything based ...
DAX Commands and Tips
RANKX issue
  • Whitewater100's avatar
    Whitewater100
    4 years ago

    Hi 😧

    I made a few changes. Brought brokers full name into your brokers table. Changed Date Table to mark as Date Table. Put new measures:

    Total Sales

    YTD Sales

    Rank Brokers

     

    I think instead of using implicit measures your better off using a measure. E.G. Total Revenue is implict. Total Sales is the measure to use. Also bring brokers name in your tables from brokers table. I don't think you need to show month sales like present. Use Month field from Dte table for all visuals. I hope this helps! I will send link in pers email.

    Rank Brokers(YTD Sales ) = RANKX(ALL('Broker Table'[Full Name]), [YTD Sales],,DESC)

    Bill

v-cazheng-msft's avatar
v-cazheng-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi DeanUW,

 

For it's something related to how to write a dax, transfer it to the right forum DAX Commands and Tips to get help from community folks.

 

Best Regards,

Community Support Team _ Caiyun