Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!
User | Count |
---|---|
101 | |
90 | |
78 | |
70 | |
69 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |