Forum Discussion
Slicer with Top N
- 1 year ago
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.
Hi @MichaelaMul,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Vinay Pabbu
Hi @MichaelaMul,
we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Regards,
Vinay Pabbu