Forum Discussion
MichaelaMul
Helper III
Helper IIISlicer with Top N
Hello! I was wondering if there's a way to create a slicer that shows the Top N of a category. So you can for example have the top brands for Apples, Oranges and Blueberries in a slicer, and the sli...
Hi MichaelaMul
You can create a numeric range parameter table which column and automatically created measure can be used to filter a rank measure.
This measure ranks all distinct values in the Model column according to their sales. The ALL function is used applied to the Model column, ensuring that filters from other related columns remain effective.
Model Rank by Sales = RANKX ( ALL ( 'Product'[Model] ), [Total Sales],, DESC, DENSE )You can create another measure to returns just the sales of the models which ranks are <= the selected rank value.
Top N Model Sales = CALCULATE ( [Total Sales], FILTER ( VALUES ( 'Product'[Model] ), [Model Rank by Sales] <= [TopN Value] ) )Please see the attached pbix.
Ashish_Mathur
Super User
Super UserHi,
Select Fruit in a slicer and in a table visual drag categories. Write this measure
Total = sum(sum(Data[units])
Measure = calculate([Total],top(3,all(Data[Category]),[Total]),values(Data[Category]))
Hope this helps.