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
mahenkj2's avatar
mahenkj2
Solution Sage
3 years ago

Hi Anonymous 

 

At first, in power query, sort the table with two columns, Manual Override_DAX and RECID (both together) and then index it.

Then in the Data view, sort the table by index.

 

Then use following formula:

NewRank = 
if
(ISBLANK(data[Manual Override_DAX])=TRUE(),
blank(),
COUNTROWS(
    FILTER(
        VALUES(data[Manual Override_DAX]),
        data[Manual Override_DAX]< EARLIER(data[Manual Override_DAX]))
)+1
)

 

NewRank would be different and lower than your example rank, becuase same values are ranked same number.

 

https://drive.google.com/file/d/1oH_LTz9g1vbAa4yhI3n1qVFfxMAEZAGd/view?usp=sharing

 

Hope it helps.