Forum Discussion
RANKX function using multiple dimensions
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
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.
1 Reply
- MFelixSuper User
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.