User selects how many items are displayed when ranking

[akos_skutovics]

In a matrix visual, I am trying to visualize the biggest customers in each product group based on turnover. One customer can have purchases in multiple product groups.

I managed to solve this with the following formula:

Rank Product = IF( ISINSCOPE( Global_Customer[Name] ), RANKX ( CALCULATETABLE ( VALUES ( Global_Customer[Name] ), ALLSELECTED ( Global_Customer[Name] ) ), [DB 1] ) )

However, I want the user to be able to select how many customers should be displayed in each product group. My approach was to create a parameter but failed to successfully implement that filter to the formula above.

[amitchandak · Accepted solution]

@akos_skutovics , If you looking sub category rank, means filter rank inside one group by refer this

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

If you are looking for TOPN

TOPN: https://www.youtube.com/watch?v=QIVEFp-QiOk&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=42