Forum Discussion
Ranking
Sorry. I forgot to add that in. The "interval" I am talking about is the From (m) column and To (m) columns. The From (m) to To (m) is an interval.
You have overlapping intervals.
that makes it impossible to determine which one "belongs" to which other one.
Yes. The overlapping intervals are the "Including" intervals.
This table below is working correctly but when I apply the code to a bigger data set is when it doesn't work properly.
Ranking =VAR current_category = SELECTEDVALUE( Sheet1[Category])VAR GXT = SELECTEDVALUE(Sheet1[GXT])RETURNIF( current_category = "Including",CALCULATE( RANK.EQ( GXT, Sheet1[GXT], DESC), FILTER( ALLEXCEPT(Sheet1, Sheet1[Date]), Sheet1[Category] = "Including")),CALCULATE( RANK.EQ( GXT, Sheet1[GXT], DESC), FILTER( ALLEXCEPT(Sheet1, Sheet1[Date]), Sheet1[Category] <> "Including")))I just don't understand why it would work for this smaller data set and not a bigger one with a year filter and more data?Please look at my screenshot. The end of the interval on line 2 (34.40) overlaps with the beginning of the interval for line 3 (34.10) .
Those are different holes.
That may be obvious to you but I am still struggling to fully comprehend your scenario and ask. Hopefully someone else can assist your.
Thanks for you time. I appreciate it.