Query for ranking

[Anonymous]

I have below data model 

Need to display below :

Most Purchased Item by Country

the most purchased product based on the age category less than 30 and above 30

[Anonymous · Accepted solution]

Hi @Sergii24 

The issue is resolved. I changed the crossfilteration to Both from Single in data model. 

Started getting correct rank post that.

Thanks!

[Sergii24]

Great, I'm glad that you found a solution! 🙂

[Sergii24]

Hi @Anonymous, so what exactly is your question to the community? How did you try to achieve the desired result and what exactly didn't work?

[Anonymous]

Hi @Sergii24 

I need to display higlighted values as they are max purchased items for each country 

trying to rank 

= RANKX(ALL('Item'[Item]), COUNT('Order'[Item ID]), ,DESC) 

but not working