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: ...
Nowhere in your source data does it say "interval" . What is an interval? Is it a combination of Site, Project and Hole?
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) .