Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
21 | |
19 | |
14 | |
11 |
User | Count |
---|---|
43 | |
35 | |
25 | |
22 | |
22 |