Forum Discussion
Rank with no duplicates
Hi sthomas38 ,
First add index:
Close and apply,then use the following dax to create a column:
RANK1 = RANKX(FILTER('Table','Table'[MSA]=EARLIER('Table'[MSA])),'Table'[Value_count]+0.000001*'Table'[Index],,DESC,Dense)Output result:
And you could refer my blog about rank with same values:
https://community.powerbi.com/t5/Community-Blog/Sort-when-with-same-value/ba-p/2012332
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Super Usersthomas38 , May this similar post help you out.
https://community.powerbi.com/t5/Desktop/Rank-values-without-duplicate-ranking/m-p/702224
Hi Tahreem,
I am not sure if I did it right, or if the solution was not right for this instance -
This is what I am getting after adding index column in Query Editor and then a RANKX Column.
VALUE for me is a Calculated Column - in my original dataset, I have IDs thats are distinctly count that created this VALUE column for me. Not sure if that helps. Even to get the RANK column - I had to create it as a Measure and not Column.