topic Exclude Blank from rankx in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Exclude-Blank-from-rankx/m-p/3169778#M114216 <P>hello everyone&nbsp;<BR /><BR />i have this measure&nbsp;<BR /><BR /></P><LI-CODE lang="markup">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&lt;=3,1, BottomRank&lt;=3,-1, blank()) return Result</LI-CODE><P><BR />this is result<BR /><BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>i dont want to include the blanks&nbsp;<BR /><BR />how can i rank without the blanks&nbsp;</P><P>&nbsp;</P> Mon, 03 Apr 2023 15:18:01 GMT eliasayyy 2023-04-03T15:18:01Z Exclude Blank from rankx https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Exclude-Blank-from-rankx/m-p/3169778#M114216 <P>hello everyone&nbsp;<BR /><BR />i have this measure&nbsp;<BR /><BR /></P><LI-CODE lang="markup">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&lt;=3,1, BottomRank&lt;=3,-1, blank()) return Result</LI-CODE><P><BR />this is result<BR /><BR /><BR /></P><P><img /></P><P>&nbsp;</P><P>i dont want to include the blanks&nbsp;<BR /><BR />how can i rank without the blanks&nbsp;</P><P>&nbsp;</P> Mon, 03 Apr 2023 15:18:01 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Exclude-Blank-from-rankx/m-p/3169778#M114216 eliasayyy 2023-04-03T15:18:01Z Re: Exclude Blank from rankx https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Exclude-Blank-from-rankx/m-p/3169868#M114224 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="434309" data-lia-user-login="eliasayyy" class="lia-mention lia-mention-user">eliasayyy</a> , try like</P> <P>&nbsp;</P> <P>BottomRank = RANKX(Summarize(filter(ALLSELECTED(Keywords),Keywords[Search keyword], "_1" ,[New]),not(isblank([_1]))), [net],,ASC,Dense)</P> Mon, 03 Apr 2023 15:45:06 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Exclude-Blank-from-rankx/m-p/3169868#M114224 amitchandak 2023-04-03T15:45:06Z