Forum Discussion

Zapas1428's avatar
Zapas1428
New Member
5 years ago

Problems with apply condition to function RANKX

First of all, I would like to introduce myself and say that it is a pleasure to be part of the community. I started working with Power BI 7 months ago and I work in the industry.   I have a problem...
Tanushree_Kapse's avatar
Tanushree_Kapse
Impactful Individual
5 years ago

Hi Zapas1428 ,

 

Try this out: 

 

RANKmeausre= 
Var currentrnk= MAX(Tabla Resumen Autobox'[Date with hour])

RETURN

RANKX(FILTER(ALLSELECTED(Tabla Resumen Autobox),Tabla Resumen Autobox'[Date with hour]= currentrnk),Tabla Resumen Autobox'[Date with hour],,ASC, Dense)

 

 

 I hope this helps.

 

Mark this as a solution if I answered your question. Kudos are always appreciated.

Thanks.