Exclude Blank from rankx

[eliasayyy]

hello everyone 

i have this measure 

Top Bottom = 

Var TopRank= 
    RANKX(ALLSELECTED(Keywords[Search keyword]),[New],,DESC,Dense)

Var BottomRank = RANKX(ALLSELECTED(Keywords),[New],,ASC,Dense)

Var Result=

SWITCH(
    TRUE(),

TopRank<=3,1,

BottomRank<=3,-1,

blank())

return 
Result

this is result

i dont want to include the blanks 

how can i rank without the blanks 

[amitchandak]

@eliasayyy , try like

BottomRank = RANKX(Summarize(filter(ALLSELECTED(Keywords),Keywords[Search keyword], "_1" ,[New]),not(isblank([_1]))), [net],,ASC,Dense)