Forum Discussion
Continuous x-axis issue
Hi Tasos,
Rank also you can calculate in power bi. Please follow these links
1. http://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
2. https://community.powerbi.com/t5/Desktop/Add-calculated-index-column-by-DAX/td-p/72448
3.https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Best Regards,
Ravi
On what logic you are gnerating that i cant understand clearly thtas why i gav you 3 links. Whatever your need you will find in these links.
I will suggest go with 3rd link first.
- Tasos7 years agoHelper II
Hello Anonymous,
Thanks for your time and the links. I do appreciate your help.
However, it still doesn't give an answer to my problem (I guess I wasn't clear). Please, see below,
The "total ranking" is a column based on total sales. The "ranking" is a measure.
As you can see, when no filters are applied, the two values are the same (as they should)
However, when filters are applied, then the "total ranking" is no longer accurate.
I am attaching again the PBI file, just in case you still have time to have a look
https://www.dropbox.com/s/31wfabuo26ropa5/pareto%20example.pbix?dl=0
Thanks again
- Anonymous7 years agoNot applicable
Hi Tasos,
I have modified pbix file with calculation of dynamic rank. Please have a look and if any concern kindly revert.
https://drive.google.com/file/d/13UnmuimhsKFiyjJ9FEZvbcBbqwyLxNQA/view?usp=sharing
Best Regards,
Ravi