Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am basically trying to get data seen below in RANK column. (sample from the same forum on a follwo up question here )
Solved! Go to Solution.
Hi @BiNewBi
in editor queries
Add Column->Extract, "last character"
"Apply & Close", then go to Report View
Create measures below
project number = SUM(Table1[Last Characters]) Measure = RANKX(FILTER(ALL(Table1),[Points]=SELECTEDVALUE(Table1[Points])),[project number],,ASC)
Best Regards
Maggie
Hi @BiNewBi
in editor queries
Add Column->Extract, "last character"
"Apply & Close", then go to Report View
Create measures below
project number = SUM(Table1[Last Characters]) Measure = RANKX(FILTER(ALL(Table1),[Points]=SELECTEDVALUE(Table1[Points])),[project number],,ASC)
Best Regards
Maggie
Hi @BiNewBi
in editor queries
Add Column->Extract, "last character"
"Apply & Close", then go to Report View
Create measures below
project number = SUM(Table1[Last Characters]) Measure = RANKX(FILTER(ALL(Table1),[Points]=SELECTEDVALUE(Table1[Points])),[project number],,ASC)
Best Regards
Maggie
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |