How to calculate bottom 1 sales in power bi dax

[likhithar]

Hello All,

I created the DAX in the following way to get bottom sales.

Var a=2

Var rank=rankx(all(products [product]),[sales],,ASC,Dense)

return 

If(rank=a,[sales])

With the above measure I'm getting correct values. Values aren't showing at category level,but I'm showing it in matrix category and product, the category is the first hierarchy and then it has to show which particular product has lowest sales  in that category.

Can someone help me out..TIA

[v-shex-msft]

Hi @likhithar ,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@likhithar , Try TOPN

Var a=2
return CALCULATE([sales], TOPN(a,ALL(products [product]),[gross],asc), VALUES(products [product]))

[likhithar]

@amitchandak Few categories were missing out when I'm using that DAX