Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
A123-Chauhan
Microsoft Employee
Microsoft Employee

Query for ranking

I have below data model 

 

A123Chauhan_0-1714472144951.png

Need to display below :

Most Purchased Item by Country

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

 

1 ACCEPTED SOLUTION
A123-Chauhan
Microsoft Employee
Microsoft Employee

Hi @Sergii24 

 

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

Started getting correct rank post that.

 

Thanks!

View solution in original post

4 REPLIES 4
A123-Chauhan
Microsoft Employee
Microsoft Employee

Hi @Sergii24 

 

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

Started getting correct rank post that.

 

Thanks!

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

Sergii24
Super User
Super User

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

Hi @Sergii24 

 

A123Chauhan_0-1714473144733.png

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.