Forum Discussion
RANKX Issues with 0s
I want my rank to start at 0 and go from there. Currently it is ranking my 0 values and the next lowest value as 1 and then ranking =RANKX(FILTER(ALLSELECTED( [Program]), [NUMBER] ), [NUMBER],,ASC) ...
amitchandak
Super User
Super UserMoonc , if both are on row and program is first and sub program is second then try like
RANK =
VAR _program = RANKX(ALLSELECTED( [Program]), [NUMBER],,ASC)
VAR _subProgram = RANKX(ALLSELECTED( [subProgram]), [NUMBER],,ASC)
Switch (True()
isinscope(subProgram,_subProgram,
isinscope(program),_program
)
The first one or the parent is always isinscope for the child
IsInScope - Switch Rank at different levels: https://youtu.be/kh0gezKICEM
amitchandak This does not work, I am seeing the program ranks correct, but the subprogram ranks are incorrect. I don't see any pattern in the rank that would help me understand.