Forum Discussion
Solved
RANKX Function - Help
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]),C...
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