Create a measure ranking based on other calculated measure

[Soof1234]

Hi,

I am struggling to create the correct measure for RANKX.

I created a measure which is a conversion rate: 

Conversie = DIVIDE(CALCULATE(COUNT(Intakes[Id]),Redenen[Title] = "Hire"),COUNT(Intakes[Id]))

I added this measure in a table and it displays correctly.

Now I want to create a measure which ranks the people from 1 to n based on the highest conversion and add this ranking number to a column.

Currently this is my output which is obviously wrong of course:

Thanks in advance!

Kind Regards,

Soof1234

[amitchandak · Accepted solution]

@Soof1234 , Try like, a new measure

Rankx(allselected(Table[Naam]), [Conversie])

more on Rank

https://www.youtube.com/watch?v=cN8AO3_vmlY&t=25627s

https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40

[Soof1234]

Thanks a lot @amitchandak , it works