Forum Discussion
Anonymous
7 years agoNot applicable
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
- Greg_Deckler
Community Champion
What happens if you ditch the DENSE?
- v-yuta-msft
Community 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.