Help needed for Rankx

[Iris03]

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]))

[Iris03]

Many thanks.😀

[Ahmedx · Accepted solution]

pls try this

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