Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm new to the RANKX function and for some odd reason the Rank Rep column is just turning up '1's as the value.
I used the following formula:
Rank Rep = RANKX(ALL('Merge1'[SalesRep]),CALCULATE(DISTINCTCOUNT('Merge1'[SalesRep])))
I need to rank each rep according to how many installs they've completed.
Solved! Go to Solution.
@Alta88 , You should use measure completed installs
Rank Rep = RANKX(ALL('Merge1'[SalesRep]),[completed installs] )
Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
@Alta88 , You should use measure completed installs
Rank Rep = RANKX(ALL('Merge1'[SalesRep]),[completed installs] )
Measure Rank: https://www.youtube.com/watch?v=DZb_6j6WuZ0&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=40
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |