Forum Discussion

jeanL's avatar
jeanL
Icon for Helper I rankHelper I
4 years ago
Solved

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

  • jeanL , Try TOPN like

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

  • CNENFRNL's avatar
    CNENFRNL
    Icon for Community Champion rankCommunity Champion
    rankings =
    RANKX(
        ALLSELECTED( summary_table[od_pairs] ),
        CALCULATE( SUM( [total_teus] ) )
    )