How to create rank

[TriveniN]

Hi,

@mcaraballo Can you help me to create rank

Note: OccupiedRent and DateDiff are the measures

Below is the sample data

NAME	OccupiedRent	DateDiff
ATL00001 - Davina Roberts - LE2	2550
ATL00089 - Marion Houston - LE1	2050
ATL00089 - Marion Houston - LE1	2250	0
ATL00096 - Nicholas M. Guerra - LE1	1900
ATL00096 - Nicholas M. Guerra - LE1	2100	0

Expected Output:

NAME	OccupiedRent	DateDiff	Rank
ATL00001 - Davina Roberts - LE2	2550		1
ATL00089 - Marion Houston - LE1	2250	0	1
ATL00089 - Marion Houston - LE1	2050		2
ATL00096 - Nicholas M. Guerra - LE1	2100	0	1
ATL00096 - Nicholas M. Guerra - LE1	1900		2

[mcaraballo]

Hi @TriveniN , hope you are doing well.

I created a table with the sample data and then I created this column:

Columna = RANKX(filter(tabla, Tabla[NAME] = EARLIER(Tabla[NAME]) ), Tabla[OccupiedRent], , DESC,Dense)

Please try this.

Regards,
Mariano.
Please, visit this idea and vote it if you like it ! Ability to show/hide any object based on a conditi... - Microsoft Fabric Community

DID I ANSWER YOUR QUESTION? PLEASE MARK MY POST AS A SOLUTION! APPRECIATE YOUR KUDO!

[mcaraballo]

Hi @TriveniN, 

Did it work? if so, please mark my post as a solution 😀

[Ahmedx]

pls try this

[TriveniN]

@Ahmedx : Thanks for quick response

getting an error when we create above column 

Can you help me out to resolve issue

error details is circualr dependency was detected

Expected Output should be below

NAME	OccupiedRent	DateDiff	Rank
ATL00001 - Davina Roberts - LE2	2550		1
ATL00089 - Marion Houston - LE1	2250	0	1
ATL00089 - Marion Houston - LE1	2050		2
ATL00096 - Nicholas M. Guerra - LE1	2100	0	1
ATL00096 - Nicholas M. Guerra - LE1	1900		2