Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

RANKX ERROR

Hey y'all I am having an issue with RANKX when I change the [order] to ASC. Below is my code and a visual from the report displaying the error. Instead of my lowest median value showing a rank of "1", it is displaying a rank of "2". I would like my values to be ranked 1,2,3,4,......    Not 2,3,4,5,.....

 

1)
 
RANK1 =
    rankx(all(Table[sample_number]),
    [median_sample_time])
 
2)
 
RANK2 =
    rankx(all(Table[sample_number]),
    [median_sample_time],,ASC,Dense)
 
 
Apppreciate the help!

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support

    Anonymous ,

     

    It's weird, could you show the DAX code in [median_sample_time] for further analysis?

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.