Forum Discussion
To use do ranking with multiple criterias
Dear Experts,
I'm quite new in DAX and would like to add new column with ranking from "Revenue" by "Material" in which the ranking itself will be changed based on "BillingDate" slicer.
I was googling and find fuction "RANKX" would fulfill me needs but it seems the result is not correct.
Please help me to advise what should I do in order to get the expected result.
Sample file.
https://www.dropbox.com/s/ikqe9pshzxp252j/Sample.pbix?dl=0
VFTrm99 - See if this helps you get to what you want. https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452
I am still not clear on what you are trying to achieve. It seems like you implemented RANKX as a column. But columns are not dynamic based upon user interaction, they are only calculated at the time of refresh. The article above will help you create a RANKX measure, which is dynamic based upon user input.
3 Replies
mhossain Thank for you advice
But it seems the result still incorrect.
For example, material 2298121 has 3 different ranks 1,3 and 5
I'm sorry my question might not be clear.
The expected result I would like to see is that;
One Material has only 1 rank and when I filter BillingDate in the slicer, the rank might or might not be changed based on Revenue in that particular period.
Sample file:
https://www.dropbox.com/s/ikqe9pshzxp252j/Sample.pbix?dl=0
- Greg_Deckler
Community Champion
VFTrm99 - See if this helps you get to what you want. https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452
I am still not clear on what you are trying to achieve. It seems like you implemented RANKX as a column. But columns are not dynamic based upon user interaction, they are only calculated at the time of refresh. The article above will help you create a RANKX measure, which is dynamic based upon user input.
