I am trying to RankX the regional manager of each team; however, manager have different size teams and hence higher sales. What I am trying to do is average out their sales / headcount and rank that; however, I am running into several spots when filtering by the month that some of the rankings are out of order, see pics. Any help is much appreciated.
Solved! Go to Solution.
@Dhutch909 , I can see a change in measure calculation when it has been used in Rank. Measure Rank is sensitive to context.Please use exact same measure at both places and check
Also For Rank Refer these links
@amitchandak I am not 100% sure what you mean? The Reg - Order Average uses the number of employees for each manager to get an average and then the Rankx compares the managers averages against each other. Is something wrong with that?
Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.
Join this community-driven Power Platform digital event for unbiased support and problem-solving.
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Visit our Community Blog for articles, guides, and information created by fellow community members.