Forum Discussion

Iris03's avatar
Iris03
Regular Visitor
2 years ago
Solved

Help needed for Rankx

I have a question about Rankx. I need to rank all brand by total unit except brand"Other".  But I don't know how to  to filter out the “Other”.

 

I write the mesure as below, it just not showing the "Other". It make me very confused about that.  I wannt to get result is A 1, C  2, B 3.

Ranking = If(AND(HASONEVALUE('Sample data'[Brand]),SELECTEDVALUE('Sample data'[Brand])<>"Other"),RANKX(All('Sample data'[Brand]),[Total unit]))

 

 

Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    pls try this

    Measure = 
ROWNUMBER(FILTER(ALL('Table'),'Table'[Cat]<>"Other"),ORDERBY([Total unit],DESC),DEFAULT)

     

2 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    pls try this

    Measure = 
ROWNUMBER(FILTER(ALL('Table'),'Table'[Cat]<>"Other"),ORDERBY([Total unit],DESC),DEFAULT)