How to rank ascending vs descending based on a field value in power bi desktop?

[nagavineela]

I am new to Power BI desktop and I got the requirement to rank different toys based on their category. In my requirement, if the toy belongs to category A, then I need to rank them in ascending order. If the toy does not fall in category A, I need to rank them in descending order.

[amitchandak · Accepted solution]

@nagavineela , Try a measure like

rankx(filter(allselected(Table[Category], Table[Item]), Table[Category]= "Category A"),[measure],,asc) +
rankx(filter(allselected(Table[Category], Table[Item]), Table[Category]= max(Table[Category]) && Table[Category]<> "Category A"),[measure],,asc)