Forum Discussion
RANKX with filter
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))
jeanL , Try TOPN like
CALCULATE([total_teus], TOPN(10,ALLSELECTED(summary_table[od_pairs]),[total_teus],dense), ALLSELECTED(summary_table[od_pairs]))
rankings = RANKX( ALLSELECTED( summary_table[od_pairs] ), CALCULATE( SUM( [total_teus] ) ) )
3 Replies
- amitchandak
Super User
jeanL , Try TOPN like
CALCULATE([total_teus], TOPN(10,ALLSELECTED(summary_table[od_pairs]),[total_teus],dense), ALLSELECTED(summary_table[od_pairs]))
- CNENFRNL
Community Champion
rankings = RANKX( ALLSELECTED( summary_table[od_pairs] ), CALCULATE( SUM( [total_teus] ) ) ) - jeanL
Helper I
CNENFRNL amitchandak Thank you! both worked perfectly!