topic Re: RankX- user to enter desired number to filter the RankX results of matrix is not working in DAX Commands and Tips

RankX- user to enter desired number to filter the RankX results of matrix is not working

ribs — Mon, 12 May 2025 14:08:58 GMT

I have a matrix in Power BI and
measures for Revenue Year 1; Revenues Year 2; RankX
parameters for Revenue Year 1; Revenue Year 2 ; TopN- for the users to choose the top count where I have a Rankif function
in the filter pane

RankIf = IF([RankX] <= 'TopN'[TopN Value]; 1; 0) set to 1 to limit the results to be displayed, which is not working because I have added customer No under the customer name to the rows pane of the matrix.

Customer	2024	2025	Dynamic Rank Compare 2024 -> 2025 or 2025->2024
A	90	50	1
B	50	60	2
C	40	40	3
D	10	20	4
E	6	70	5

Everything is working except the RankIf in filterpane so that user cannot enter manually how many top rows to display. I don't know where exactly I am going wrong. I tried to replicate the same in the attcahed below

Re: RankX- user to enter desired number to filter the RankX results of matrix is not working

bhanu_gautam — Tue, 13 May 2025 05:44:23 GMT

ribs Try using

RankX Measure: RankX = RANKX(ALL('Customer'), [Revenue Year 1], , DESC, DENSE)

RankIf Measure: RankIf = IF([RankX] <= SELECTEDVALUE('TopN'[TopN Value]), 1, 0)

TopN Parameter Table: TopN = GENERATESERIES(1, 10, 1)

Go to the matrix visual.
Drag the RankIf measure to the Visual Level Filters pane.
Set the filter to show only rows where RankIf equals 1.

Re: RankX- user to enter desired number to filter the RankX results of matrix is not working

ribs — Tue, 13 May 2025 08:22:25 GMT

bhanu_gautam I have tried this already it is not working.In the matrix rows pane I have two columns- Customer and Customer No like the image below. Because of the subategory Customer No, the RankIf is not working. Is it possible to not to apply ranking to the subcategory? Or if at all applied, not to cosnider in RankIf()?

Re: RankX- user to enter desired number to filter the RankX results of matrix is not working

v-sdhruv — Fri, 16 May 2025 10:58:52 GMT

Hi ribs ,
You can try this DAX

RankX =

IF(

ISINSCOPE('Customer'[Customer Name]) && NOT ISINSCOPE('Customer'[Customer No.]),

RANKX(

ALLSELECTED('Customer'[Customer Name]),

[Revenue Change],

DESC,

DENSE

)

This makes Rankx return blank at the Customer No. level, so it doesn’t affect or show on subcategories.

Attached file for reference.
Hope this helps!
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

Re: RankX- user to enter desired number to filter the RankX results of matrix is not working

ribs — Mon, 19 May 2025 13:43:35 GMT

v-sdhruv Thank you so much! This solution is close enough to my requirement. I'll try to find a workaround as the RankX disappears when I drilldrown the visual to view one or all the customer number.

Re: RankX- user to enter desired number to filter the RankX results of matrix is not working

v-sdhruv — Tue, 20 May 2025 06:40:54 GMT

Hi ribs ,
Good to know you were able to arrive at the solution.
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

Re: RankX- user to enter desired number to filter the RankX results of matrix is not working

v-sdhruv — Wed, 21 May 2025 10:44:59 GMT

Hi @ribs ,
Good to know you were able to arrive at the solution.
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You!