Forum Discussion
undefined
When in Matrix we put the branch nad customer by revenue and we want to top 5 customer by revenue each branch how will we do that?
Anonymous , use TOPN measure
calculate([revenue], TOPN(5,allselected(Table[Customer]), [Revenue],desc))
Assuming revenue is a measure
You can use TOPN/Window
Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ