Hi everyone,
after getting a great help of @harshnathani on building my Projects/products scoring system i have a new problem.
i will have a scoring system where im ranking each parameter (sales, CM1, Risk, etc) based on %iles of each parameter.
in the end, i will have a simple algorithm with the respective weights for each parameter, resulting in a total Score.
From the total score, i created a RankX function in order to have a Piority list from 1 til XXX.
As some of the total score can be identical, RankX is showing several duplicates.
apagarRank_test = Rankx(allselected(Sales[Project No.]),[Rank on %ile],,desc)
| Project No. | Total Sales by Project No | Rank on %ile | apagarRank_test |
| XXX171001 | 238.93 | 5 | 1 |
| XXX115001 | 219.74 | 5 | 1 |
| XXX152002 | 153.61 | 5 | 1 |
| XXX152001 | 146.12 | 4 | 4 |
| XXX111001 | 131.12 | 4 | 4 |
| XXX252501 | 123.93 | 4 | 4 |
| XXX111005 | 103.2 | 3 | 7 |
| XXX113001 | 93.5 | 3 | 7 |
| XXX156004 | 86.14 | 3 | 7 |
| XXX113002 | 63.86 | 2 | 10 |
| XXX111002 | 59.18 | 2 | 10 |
| XXX111004 | 52.33 | 2 | 10 |
| XXX111501 | 37.12 | 1 | 13 |
| XXX171501 | 29.7 | 1 | 13 |
| XXX354501 | 7.93 | 1 | 13 |
I saw differen complex ways of doing by adding for ex. RAND and other ways which for me as a total noob is complicated.
any way of doing as simple as possible? would be possible to add "total sales by proj no" as a second parameter to untie the final result? i just need a prio with 1,2,3,4 etc.. pbix file bellow
Thanks for any help
PBIX File
