Forum Discussion
Show TOP 250 Items as a Static Row
@Sumanthjb, typically if you created a Rank as a
Rankx(all(Table[prodcut]), [product sold])
It means product range within any other group by, if nothing then product. If you choose the company, then the top 250 within the product.
If you want to force any subcategory of specific use thin Range
See example in
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415@Sumanthjb
Try to create a slicer to select the date range, and use the TOP n filter in the table visual to filter the top 250 product based on the sales value.
Paul Zheng _ Community Support Team
If this post helps, then consider Accept it as the solution to help other members find it faster.
@Sumanthjb
Try to create a slicer to select the date range, and use the TOP n filter in the table visual to filter the top 250 product based on the sales value.
Paul Zheng _ Community Support Team
If this post helps, then consider Accept it as the solution to help other members find it faster.