removing filter context for a switch formula

[BobKoenen]

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 create A podium visual with a bar chart. 

My data looks like this:

Category	Sum of sales	Rank	Desired measure result
A	1200	3	3
B	1500	1	2
C	1300	2	1

So If the Rank = 1 then 2, IF rank =2 then 1, IF rank =3 then 3

I Tried to use the following formula but it returns only 2 probably because of the row filter context.

 SWITCH(

Rank,1,2,

 Rank,2,1,

Ranks,3,3))

 
Hope you can help me

[CNENFRNL]

Measure = SWITCH([RANK],1,2,2,1,3)

[tamerj1 · Accepted solution]

@BobKoenen 

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

should be 

SWITCH (

TEUE ( ),

Rank,1,2,

 Rank,2,1,

Ranks,3,3)