Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
88 | |
82 | |
65 | |
64 | |
58 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |