rankx in matrix return 1 for all

[rob7one]

Hi guys,

i use this rankx measure on a matrix visual:

A_rank top 5 history 2 = RANKX(ALL(a_notifi_list[vendor name]), CALCULATE(SUM(a_notifi_list[Defectives)])))

it seems to work in a table, but when i use it in a matrix like you can see below, it shows me for each vendor the value "1". i think that could be vendors which are not present with defects in the column of the month, but i'm not sure. Do you know how i can fix this? on the left side of the matrix are all vendors listed row by row.

[amitchandak]

@rob7one , Not very clear, try like

A_rank top 5 history 2 = RANKX(ALLselected(a_notifi_list[vendor name]), CALCULATE(SUM(a_notifi_list[Defectives)])))

Or try to use window with partition by

Dynamic TOPN using TOPN/Window and Numeric parameter: https://youtu.be/vm2mdEioQPQ