Forum Discussion
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...
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
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)