Forum Discussion
satindenave
6 years agoFrequent Visitor
Dynamic INDEX/RANK creation using DAX
ORIGINAL DATA Company Department Job Level Score C1 D5 Executive Management 0.64 C1 D4 Executive Management 0.17 C1 D2 Executive Management 0.06 C1 D1 Middle Managemen...
Greg_Deckler
6 years agoCommunity Champion
satindenave - These might help:
https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Mythical-DAX-Index/td-p/1093214
- satindenave6 years agoFrequent Visitor
Greg_Deckler Thanks for taking out your time to provide the solution. It worked for me with a small change in the DAX.
- Greg_Deckler6 years agoCommunity Champion
satindenave - Glad to hear it!