topic Re: RankX not correct with measure for average sales in DAX Commands and Tips

RankX not correct with measure for average sales

Dhutch909 — Thu, 25 Jun 2020 23:19:28 GMT

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.

Re: RankX not correct with measure for average sales

amitchandak — Fri, 26 Jun 2020 02:24:19 GMT

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
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415

Re: RankX not correct with measure for average sales

Anonymous — Fri, 26 Jun 2020 05:06:31 GMT

Hi Dhutch909 ,

RANK = RANKX ( ALLSELECTED ( 'Service Territory'[Regional Manager] ), [Reg-Order Average] )

Regards,

Harsh Nathani

Re: RankX not correct with measure for average sales

Dhutch909 — Fri, 26 Jun 2020 14:11:14 GMT

Anonymous This resuts in The end of the inpt was reached, error.

Re: RankX not correct with measure for average sales

Dhutch909 — Fri, 26 Jun 2020 14:13:18 GMT

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?

Re: RankX not correct with measure for average sales

Dhutch909 — Fri, 26 Jun 2020 14:37:06 GMT

Anonymous amitchandak

I have it figured out. I am pulling head count from an employee table and order values from an order table for the average. I had to change the relationship on my tables to filter both. Previously the employee table was filtering the order table.