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
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