Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

removing filter context for a switch formula

Hi all,   I have a sum measure and a RankX measure based on the Sum Measure. Now I want to create a measure which uses the output of the Rankx Measure to change this number in order to be able to c...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

    It should work. Did you use correct syntax of SWITCH funtion?

    should be 

    SWITCH (

    TEUE ( ),

    Rank,1,2,
     Rank,2,1,
    Ranks,3,3)
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago
Measure = SWITCH([RANK],1,2,2,1,3)