RANKX with filter

[jeanL]

I am trying to display only top 10 in the table and have been looking up to try using TOPN and RANKX.

But i have been having issue with rankx, with it displaying 1 rank across the table.

The table is expected to be filtered by three criteria, 

1. main_service

2. direction 

3. customer_segment

I have tried using adding columns and it gives me the ranks throughout the entire table. But i am looking for a dynamic ranking where it will be ranked as the filter is applied. 

rank = RANKX(ALLSELECTED(summary_table), [total_teus],,0)

rank is using new column with the above code, while rankings, i have been trying with code below. 

rankings = CALCULATE(
    RANKX(ALLSELECTED(summary_table[od_pairs]), SUM([total_teus]),,0))

[amitchandak · Accepted solution]

@jeanL , Try TOPN like

CALCULATE([total_teus], TOPN(10,ALLSELECTED(summary_table[od_pairs]),[total_teus],dense), ALLSELECTED(summary_table[od_pairs]))

[jeanL]

@CNENFRNL @amitchandak  Thank you! both worked perfectly! 

[CNENFRNL · Accepted solution]

rankings =
RANKX(
    ALLSELECTED( summary_table[od_pairs] ),
    CALCULATE( SUM( [total_teus] ) )
)

[amitchandak · Accepted solution]

@jeanL , Try TOPN like

CALCULATE([total_teus], TOPN(10,ALLSELECTED(summary_table[od_pairs]),[total_teus],dense), ALLSELECTED(summary_table[od_pairs]))