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

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

Good Morning,

Your original DAX measures that you made on my file yesterday were the correct solution.  I did have to rebuild the entire report based on you feedback of using the dates incorrectly.  Once I rebuilt the 'Sales Totals' table to leverage the 'Date Table' more effectively your YTD & Total Sales DAX measures worked perfectly.  Thank you again for the different perspective on how to build it.  Have a great weekend!

Whitewater100's avatar
Whitewater100
Icon for Solution Sage rankSolution Sage
4 years ago

Great and you are welcome!