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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AaronGlenn10
Helper III
Helper III

Ranking a City within a State based on Sales

Power BI Rock Stars:  I have a database of restaurant sales for the state of Texas that are grouped by cities.  When the user selects a city for analysis, it would be cool to provide the city's overall ranking within the state based on most recent sales reported.  For example - Houston #1, Dallas, #2, etc...  Thank you!

 

AaronGlenn10_0-1644963360431.png

 

1 ACCEPTED SOLUTION
TheoC
Super User
Super User

Hi @AaronGlenn10 

 

Here is a link that I believe will provide you the outcome you are after: https://community.powerbi.com/t5/Desktop/Ignore-slicer-in-ranking-measure/m-p/560833

 

It basically is a RANKX measure that ignores slicers. 

 

Cheers,

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

2 REPLIES 2
TheoC
Super User
Super User

Hi @AaronGlenn10 

 

Here is a link that I believe will provide you the outcome you are after: https://community.powerbi.com/t5/Desktop/Ignore-slicer-in-ranking-measure/m-p/560833

 

It basically is a RANKX measure that ignores slicers. 

 

Cheers,

Theo

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

That worked - thank you so much!

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.