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 Management | 0.86 |
C1 | D5 | Junior Management | 0.64 |
C1 | D4 | Junior Management | 0.95 |
C1 | D4 | Junior Management | 0.17 |
C1 | D1 | Junior Management | 0.37 |
C1 | D5 | Executive Management | 0.27 |
C1 | D3 | Junior Management | 0.05 |
C1 | D5 | Senior Management | 0.97 |
C1 | D3 | Senior Management | 0.42 |
C2 | D4 | Senior Management | 0.68 |
C2 | D1 | Middle Management | 0.68 |
C2 | D2 | Junior Management | 0.17 |
C2 | D1 | Junior Management | 0.46 |
C2 | D4 | Middle Management | 0.24 |
C2 | D4 | Junior Management | 0.85 |
C2 | D4 | Junior Management | 0.88 |
C2 | D1 | Senior Management | 0.50 |
C2 | D3 | Executive Management | 0.61 |
C2 | D4 | Junior Management | 0.15 |
C2 | D1 | Junior Management | 0.65 |
C2 | D1 | Senior Management | 0.12 |
C2 | D5 | Executive Management | 0.10 |
C2 | D4 | Middle Management | 0.52 |
C3 | D4 | Junior Management | 0.61 |
C3 | D5 | Senior Management | 0.35 |
C3 | D4 | Junior Management | 0.73 |
C3 | D2 | Junior Management | 0.29 |
C3 | D3 | Junior Management | 0.27 |
C3 | D2 | Junior Management | 0.97 |
C3 | D4 | Executive Management | 0.65 |
C3 | D5 | Middle Management | 0.81 |
C3 | D1 | Middle Management | 0.39 |
C3 | D2 | Junior Management | 0.32 |
C3 | D4 | Middle Management | 0.07 |
C3 | D1 | Junior Management | 0.96 |
C3 | D4 | Middle Management | 0.33 |
C3 | D3 | Middle Management | 0.56 |
DATA WITH INDEX COLUM 1 | ||||
Company | Department | Job Level | Score | Index Column 1 |
C1 | D1 | Middle Management | 0.86 | 1 |
C1 | D1 | Junior Management | 0.37 | 2 |
C1 | D2 | Executive Management | 0.06 | 1 |
C1 | D3 | Senior Management | 0.42 | 1 |
C1 | D3 | Junior Management | 0.05 | 2 |
C1 | D4 | Executive Management | 0.17 | 1 |
C1 | D4 | Junior Management | 0.95 | 2 |
C1 | D4 | Junior Management | 0.17 | 3 |
C1 | D5 | Executive Management | 0.64 | 1 |
C1 | D5 | Executive Management | 0.27 | 2 |
C1 | D5 | Senior Management | 0.97 | 3 |
C1 | D5 | Junior Management | 0.64 | 4 |
C2 | D1 | Senior Management | 0.50 | 3 |
C2 | D1 | Senior Management | 0.12 | 4 |
C2 | D1 | Middle Management | 0.68 | 5 |
C2 | D1 | Junior Management | 0.65 | 6 |
C2 | D1 | Junior Management | 0.46 | 7 |
C2 | D2 | Junior Management | 0.17 | 2 |
C2 | D3 | Executive Management | 0.61 | 3 |
C2 | D4 | Senior Management | 0.68 | 4 |
C2 | D4 | Middle Management | 0.52 | 5 |
C2 | D4 | Middle Management | 0.24 | 6 |
C2 | D4 | Junior Management | 0.88 | 7 |
C2 | D4 | Junior Management | 0.85 | 8 |
C2 | D4 | Junior Management | 0.15 | 9 |
C2 | D5 | Executive Management | 0.10 | 5 |
C3 | D1 | Middle Management | 0.39 | 8 |
C3 | D1 | Junior Management | 0.96 | 9 |
C3 | D2 | Junior Management | 0.97 | 3 |
C3 | D2 | Junior Management | 0.32 | 4 |
C3 | D2 | Junior Management | 0.29 | 5 |
C3 | D3 | Middle Management | 0.56 | 4 |
C3 | D3 | Junior Management | 0.27 | 5 |
C3 | D4 | Executive Management | 0.65 | 10 |
C3 | D4 | Middle Management | 0.33 | 11 |
C3 | D4 | Middle Management | 0.07 | 12 |
C3 | D4 | Junior Management | 0.73 | 13 |
C3 | D4 | Junior Management | 0.61 | 14 |
C3 | D5 | Senior Management | 0.35 | 6 |
C3 | D5 | Middle Management | 0.81 | 7 |
DATA WITH INDEX COLUMN 2 | |||||
Company | Department | Job Level | Score | Index Column 1 | Index Column 2 |
C1 | D2 | Executive Management | 0.06 | 1 | 1 |
C1 | D4 | Executive Management | 0.17 | 1 | 2 |
C1 | D5 | Executive Management | 0.64 | 1 | 3 |
C1 | D3 | Senior Management | 0.42 | 1 | 4 |
C1 | D1 | Middle Management | 0.86 | 1 | 5 |
C1 | D5 | Executive Management | 0.27 | 2 | 6 |
C1 | D1 | Junior Management | 0.37 | 2 | 7 |
C1 | D3 | Junior Management | 0.05 | 2 | 8 |
C1 | D4 | Junior Management | 0.95 | 2 | 9 |
C1 | D5 | Senior Management | 0.97 | 3 | 10 |
C1 | D4 | Junior Management | 0.17 | 3 | 11 |
C1 | D5 | Junior Management | 0.64 | 4 | 12 |
C2 | D2 | Junior Management | 0.17 | 2 | 1 |
C2 | D3 | Executive Management | 0.61 | 3 | 2 |
C2 | D1 | Senior Management | 0.50 | 3 | 3 |
C2 | D1 | Senior Management | 0.12 | 4 | 4 |
C2 | D4 | Senior Management | 0.68 | 4 | 5 |
C2 | D5 | Executive Management | 0.10 | 5 | 6 |
C2 | D1 | Middle Management | 0.68 | 5 | 7 |
C2 | D4 | Middle Management | 0.52 | 5 | 8 |
C2 | D4 | Middle Management | 0.24 | 6 | 9 |
C2 | D1 | Junior Management | 0.65 | 6 | 10 |
C2 | D1 | Junior Management | 0.46 | 7 | 11 |
C2 | D4 | Junior Management | 0.88 | 7 | 12 |
C2 | D4 | Junior Management | 0.85 | 8 | 13 |
C2 | D4 | Junior Management | 0.15 | 9 | 14 |
C3 | D2 | Junior Management | 0.97 | 3 | 1 |
C3 | D3 | Middle Management | 0.56 | 4 | 2 |
C3 | D2 | Junior Management | 0.32 | 4 | 3 |
C3 | D2 | Junior Management | 0.29 | 5 | 4 |
C3 | D3 | Junior Management | 0.27 | 5 | 5 |
C3 | D5 | Senior Management | 0.35 | 6 | 6 |
C3 | D5 | Middle Management | 0.81 | 7 | 7 |
C3 | D1 | Middle Management | 0.39 | 8 | 8 |
C3 | D1 | Junior Management | 0.96 | 9 | 9 |
C3 | D4 | Executive Management | 0.65 | 10 | 10 |
C3 | D4 | Middle Management | 0.33 | 11 | 11 |
C3 | D4 | Middle Management | 0.07 | 12 | 12 |
C3 | D4 | Junior Management | 0.73 | 13 | 13 |
C3 | D4 | Junior Management | 0.61 | 14 | 14 |
Please remeber i need a measure which changes on the basis of slicer. There are 14 more filters to slice and dice the data so calculated column won't work.
I have created a SQL query to understand the desired outcome
Solved! Go to Solution.
@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
@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
@Greg_Deckler Thanks for taking out your time to provide the solution. It worked for me with a small change in the DAX.
@satindenave - Glad to hear it!
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
97 | |
76 | |
42 | |
30 | |
30 |
User | Count |
---|---|
134 | |
95 | |
78 | |
47 | |
39 |