Rankx displaying not properly

[Anonymous]

I have table where I want to show the ranking index by total import value. However, the ranking index is not correct. I attached my measure and table. What is the problem? There is no filter applied.

[Anonymous]

HI @Anonymous,

I think it may be related to all functions that you apply to your rankx parameter table/fields. AFAIK, all functions will ignore other filter effects. You can also take a look at the following link to know more about all functions:

Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT 

Regards,

Xiaoxin Sheng

[Greg_Deckler]

@Anonymous - See if this helps:

https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452

[amitchandak]

@Anonymous , something wrong with the combination. Can you share sample data and sample output in table format?

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

[Anonymous]

Dear @amitchandak if i share this file with you can help me?

[amitchandak]

@Anonymous , Sure. Please also mark @Greg_Deckler and @Anonymous  while sharing the file. We will try to help you.