How to dynamically show Top/Bottom 20 Rows based off Values and Time slicer in Matrix Table

Hi derekli1700,

Thank you for reaching out in Microsoft Community Forum.

Please follow below steps for desired output;

1.Rank Stores by sales using RANKX and filter Top 20 and Bottom 20 stores into a combined table.

2.Rank Customers within each store and flag only the Top 5 using a DAX measure.

3.Use a Matrix visual with Store > Customer hierarchy and apply filters for the ranked stores and customers.

4.Create a Sales measure to show total store sales at the store level and top 5 customer sales when drilled down.

Please continue using Microsoft Community Forum.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.