Forum Discussion
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 = ...
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.
cchilton
Could you please give me sample data, so I can test my suggestions please?