Bottom 5 Ranks is not working in power BI

[Anonymous]

Hi All,

we have one requirement like need to display Top5/Bottom 5 dynamically based on user selections using slicer like  Top5/Bottom 5 along with other Region slicer

whenever we selects any region am getting correct ranks but if region slicer is selected with "All" Bottom5 rank is showing only 4 Ranks and it is not displaying 1st rank and tried using diff suggestions from community like using  Allnonblankrow/CalculateTable..

but still no use.

Logic used for this:

GN_Botton5_Sales = CALCULATE([SG_totsales],FILTER(VALUES('GNS_Sample - Superstore'[Customer Name]),

IF(RANKX(ALL('GNS_Sample - Superstore'[Customer Name]),[SG_totsales],,ASC,Dense)<=5,[SG_totsales],0)))

Could anyone please help me on this.

Thank you in advance

[amitchandak]

@Anonymous , Refer if this can help

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415