RANKX FUNCTION IN A TABLE VISUAL

[nicolas_nsto]

I have a data base of engine models sales. This data also contains specific technical characteristics about this products as power, rotations per minute (RPM), etc. 

I have applied a RANKX function to sort all models of products by the volum of sales as described below:

RANK = RANKX(ALL(M_Diesel[MODELO]), [QTDE TOTAL]),

Then, I created table visual with the columns "Model", "Sale volume" and "Ranking Order". Until this point, ok. However, I tried to insert other two columns of my query to show the technical characteristics for each model (power and RPM). As both of these datas are formatted as number type, I chose the option "Don't summarize" for these columns, so the values in the table would not appears as a sum calculation for each model, but as the exact power/rpm value of the respective product. The problem is when I applied this option, the rank column is no longer appropriately sorted, the position 1, 2 and 3 is reppeated for many models. 

Do someone know how can I solve this?

Tks. 

[lbendlin · Accepted solution]

it is now computing the rank of your model for the filter context of your added columns.  You need to change the RANKX measure to remove that filter context again, so that the computation stays on Model level.

[nicolas_nsto]

Great, it was simpler than I thought! Thank you so much.

[Padycosmos · Accepted solution]

Hope this video helps:

https://www.youtube.com/watch?v=tS1ff6ouORg

[nicolas_nsto]

I appreciate the video, it helped me, thanks!

[lbendlin · Accepted solution]

it is now computing the rank of your model for the filter context of your added columns.  You need to change the RANKX measure to remove that filter context again, so that the computation stays on Model level.