RANKX Only Returning 1

Question

Hello,&nbsp;I was hoping you would be able to help me. I have tried various options from other forum posts, but have not got anywhere.&nbsp;I have created a RANKX formula to rank the sites I have, by the number of tickets they have issued, but it always ranks all of the sites as 1 in my table.&nbsp;I originally used this DAX fomula, with no sucess:&nbsp;Site Rank = RANKX ( ALLSELECTED(V_Locations[Location Name]), CALCULATE([Total Issued])),, DESC, DENSE)&nbsp;[Total Issued] =&nbsp;DISTINCTCOUNT(R_Issued[Reference]) - R_Issued is the list of tickets issued.&nbsp;I then tried the following, based on another post, which worked for them, but I still get them all as 1:&nbsp;Site Rank = RANKX ( ALLSELECTED(V_Locations[Location Name]), CALCULATE(DISTINCTCOUNT(R_Issued[Reference])),, DESC, DENSE)&nbsp;Could anyone tell me what I am doing wrong?&nbsp;Any help would be much appreciated!&nbsp;Best wishes,Helen

amitchandak · Accepted Answer

HelenBrunyee , If you use any other column in visual than V_Locations[Location Name]) then rank will repeat inside that column .
Assume you use location id , then you will get all rank as 1, as there is only one location inside location id
&nbsp;
then you have to try
&nbsp;
Site Rank = RANKX (ALLSELECTED(V_Locations[Location Name],V_Locations[Location ID]), CALCULATE(DISTINCTCOUNT(R_Issued[Reference])),, DESC, DENSE)
&nbsp;
For Rank Refer these linkshttps://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measureshttps://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columnshttps://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
&nbsp;

Forum Discussion

RANKX Only Returning 1

2 Replies

Related content

RANKX Formula Returning Duplicate Ranks

Rankx all return 1

RANKX Always Returns 1

RankX

RANKX returning duplicate values