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)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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)