Forum Discussion
Ranking
What I am looking for is to create a Ranking from my GXT column and if my category column Contains "Including" to give it the same rank as the interval it belongs with: See how each color belongs in the same interval?
This first table works and is what I want but when I apply it to my table with more sites and years (See below table) it gets all messed.
This table is not filtering correctly when i select the year and the ranking is not working.
I hope this makes more sense.
thanks,
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?