RANKX function using multiple dimensions

[Ani26]

Hi Team,

I need to show rank based on a measure named [CF $B].

I am using a table visual and I pull fields into the table from 3 different dimension tables.
Below is the table visual where Fund name, Provider, Listed region columns are from different dimension tables. AUM and CF are the measures based on the Fact table.

I have used the below formula to derive the ranking

TF_Rank = 
rankx(crossjoin(allselected('Fund'[Fund Name]),allselected('Provider'[Provider]),ALLSELECTED('Region'[Listed Region])),[CF $B])

and I get the ranking as well from 1 onwards. But I need to show only top 10. Hence as soon as I apply filter to show only top 10 values, the ranking changes as below which was 1,2,3....10....so on... before

How do I get only the top 10 ranks using the above measure or do i need to apply any explicit filter condition.

Thanks.

Ani

[MFelix · Accepted solution]

Hi @Ani26 ,

You need to do a "merge" between the RANK and the TOPN.

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

 And check the alternative approach.