Least value by date

My Dax : least_rank = RANKX(ALLEXCEPT(Data,Data[Date]),[Site Open %],,DESC,Dense)   I want to get ranks based on site open % which is itself a measure. and then use the rank to filter lowes...