Forum Discussion
PBI_quest
4 years agoRegular Visitor
Top N problem
ok so I have a matrix that looks like this in powerBI (CATEGORY and CUSTOMER NUMBER are my rows) When i try to filter my customer with top 5 by Total A + B, PowerBI give me 5 customer in o...
amitchandak
Super User
4 years ago
Rankx(Allselected(Table[Category], Table[Customer]), [Measure],,desc,dense)
For the above measure filter rank <=5
- PBI_quest4 years agoRegular Visitor
I don't understand what i'm supposed to write for measure filter rank <= 5?