Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to Solution.
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
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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
64 | |
59 | |
56 |