undefined

[Anonymous]

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?

[Adamboer]

To show the top 5 customers by revenue for each branch in a matrix, you can follow these steps:

1. Add the Branch and Customer columns to the matrix.

2. Add the Revenue measure to the matrix.

3. Click on the Revenue measure in the Values pane and select "Value Field Settings."

4. In the "Value Field Settings" window, select the "Advanced" option.

5. In the "Advanced" window, select the "By Category" option.

6. In the "By Category" window, select the "Top" option and set the value to 5.

7. Select the "Branch" column in the matrix.

8. In the "Visualizations" pane, click on the "Format" button.

9. In the "Format" window, select the "Top N" option and set the value to 5.

This will show the top 5 customers by revenue for each branch in the matrix. The matrix will be sorted by revenue, with the top 5 customers for each branch displayed.

[amitchandak]

@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