Dynamic Rank(Measure)

[ngct1112]

Hi All,

In my model, Could I create a measure that having a dynamic ranking list after users choosing the Currency Conversion.

The rank is based on the 'Price'(ASC) of each ID.

Please be noted that the 'Price' itself is already a measure.

Great thanks with your help!

ID	Price	Rank(measure)
1	10	4
1	4	2
1	8	3
1	2	1
2	12	3
2	6	2
2	5	1

[amitchandak · Accepted solution]

@ngct1112 , if the price is a measure , you need any other column like index or date to get that rank as a measure 

Measure rank = rankx(filter(allselected(Table[ID], Table[index]), [ID] = max([ID])), [Price])

Index column in power query

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

[ngct1112]

@amitchandak Great thanks. Your method is workable