I am looking at providing visuals that give
Top 5 customers by Sales this period
Top 5 customers by Sales last period
Bottom 5 customers by Month on month
Top5 Customers (Current Sales) = CALCULATE( [Sales], TOPN( 5, ALL('Customer[Customer Name]) ), [Sales], DESC ), VALUES( 'Customer[Customer Name])
Where this falls short is I want to ignore [customer Name] = “No Name” AND [customer Name] = “”
When I have done the Bottom 5 I have sometimes got 3 results back where the 3 are negative values and then a lot of customers have tied for 4th on zero sales.
How do I avoid these results and always get 5 rows? Been banging head on table and its not helping.