Forum Discussion
To use do ranking with multiple criterias
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.
Solution Sage
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.