topic removing filter context for a switch formula in DAX Commands and Tips

removing filter context for a switch formula

Anonymous — Wed, 22 Jun 2022 09:15:32 GMT

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

Re: removing filter context for a switch formula

tamerj1 — Wed, 22 Jun 2022 10:43:36 GMT

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)

Re: removing filter context for a switch formula

CNENFRNL — Wed, 22 Jun 2022 12:39:35 GMT

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