Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Problems with Rankx, Dense

Hi all:   This is my first post, so I appreciate y'alls help here.  I thought I have a fairly simple problem. But not so much...See underneath for a report. What I need is just a column called ran...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for flagging. Underneath please find the link to desired outcome. Please let me know your thoughts on how to achieve the rank with a DAX function (not a measure, because I want to visualize it as a ficticious datapoint on the x-axis). Note the Blanks at the bottom. Thank you!

    Link to csv on google drive 

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      There are some slight disagreements with your desired ranking but this formula is good enough:

       

       

       

      Rank = rankx(filter(ALL('data (4)'),not ISBLANK([Value])),[Value]+VALUE([RECID])/1000000000000,,ASC,Dense)