Forum Discussion

cchilton's avatar
cchilton
Helper I
3 years ago

RANKX Allselected and Filtering Data

I have a table of values I want to Rank in order. The column value is a calculated measure. It is not just a column in a table.    When I use this formula I get the following output:  Rank Name = ...
Need Help
vojtechsima's avatar
vojtechsima
Super User
3 years ago

Hi, cchilton ,
Can't you calculate the rank as Calculated Column?

Something like this:

Rank = RANKX(FILTER(Ranking, Ranking[Name] <= EARLIER(Ranking[Name])), Ranking[Name],,ASC, Dense)

And then it stays every time the same?

 

 

 
cchilton's avatar
cchilton
Helper I
3 years ago

Thank you for your response! I tried what you suggested and this didn't work for me. My table has millions of rows and in prod more rows will be added all the time. Thus get an error saying there isn't enough memory so I think it has to be a measure. 

 

I did find this when researching and this almost works. 

Rank =
RANKX(
FILTER(
ALL(Table[column]),
NOT(ISBLANK([Measure]))
),
[Measure],,ASC,Dense

)

 

This is the result. It is missing numbers and row 1 is duplicated. From what I have found the issue has something to do with Blanks? I am very new to DAX and Power Bi so I am not sure. I am closer to an answer though so that makes me hopeful. 

 

  • vojtechsima's avatar
    vojtechsima
    Super User
    3 years ago

    cchilton 
    Could you please give me sample data, so I can test my suggestions please?