I created a dynamic ranking table for my Top 10 Customers following the “Dynamic Grouping with Ranking Logic” video. This works and has worked very well form me. However, this time I’m trying to put my ranked customers in a matrix table where the top category is the Rank Group and the category below that is the Customer Group. (Don’t get confused - my “Customer Group” is really the Customer Name. The Customer Rank Group is my table shown below.)
Here is my measure:
Total Sales by Rank = CALCULATE( [Total Sales], FILTER( VALUES( PBI_AEP_CustMaster135[Customer Group] ), COUNTROWS( FILTER( 'Customer Rank Group', RANKX( ALL( PBI_AEP_CustMaster135[Customer Group] ), [Total Sales],, DESC ) >= 'Customer Rank Group'[Min] && RANKX( ALL( PBI_AEP_CustMaster135[Customer Group]), [Total Sales],, DESC ) <= 'Customer Rank Group'[Max] ) ) > 0 ) )
My Customer Rank Group table is this:
Here is my result. As you can see the highlighted Customer Names show up in both the Top 10 (which they are not) without totals and also under “All Others” with Totals (as it should be). What is causing this?