Forum Discussion
Help with RANKX - Returning 1 for All Values
I am having trouble with RANKX- I am getting a 1 for each ranking. I am trying to rank donations by Household ID. I have a measure to sum up the donations for the period: Donation for Pd = cal...
Ok, so I set this up in a visual. When I add the fields Donation for Pd and Household ID it works perfectly. I have another table that contains Household Name in a separate linked table.
When I add in the Household Name field in the visual, this is what breaks my ranking and shows all as #1. Do I need to somehow include this Household Name field in my formula?
Instead of using ALLSELECTED(Donation_Distributions[Household ID]), just use ALLSELECTED(Donation_Distributions). This returns all the columns of the Donation_Distributions table, instead of just the column of ID numbers.
Try:
Household Rank2 = RANKX (ALLSELECTED(Donation_Distributions), [Donation for Pd] )