Forum Discussion
Solved
Power BI Dynamic Title for Matrix Table based on Customer Rank - Individual rank
I having trouble getting the title to show up on a matrix table. I have created several matrix tables for monthly sales over fiscal years. I created a Customer Rank Measure and also created another...
superlangford , you can use Index function for that
You need a measure like
maxx(index(1, allselected(Table[Customer]), orderBy([Your Measure], desc)) [Customer])
Ideally, if customer is context, Rank =1 should filter it
Continue to explore Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Thank you. While your formula did not exactly solve the issue, I was able to work out a solution from the Index Function.
One follow up, is that with the index function and selecting 1, we are hardcoding that into the formula. I thus would need to create multiple in order to get Rank = 5, Rank =7, etc. Sounds trivial, but it is an interesting challenge.