Forum Discussion
Ranking
Hi. Is there a way to Rank a specific column (GXT) but if there is an "Including" in the Category Column then keep those intervals together? I hope someone can help me. Thanks a bunch! Example: ...
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])
RETURN
IF( 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.