Forum Discussion
Rankx displaying not properly
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.
5 Replies
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/367415Dear amitchandak if i share this file with you can help me?
Anonymous , Sure. Please also mark Greg_Deckler and Anonymous while sharing the file. We will try to help you.
Anonymous - See if this helps:
https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452
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
