Forum Discussion

PHDurand's avatar
PHDurand
Helper I
7 years ago

Help - Switch formulas for dynamic column selection

Hi,

I need some help on using the SWITCH function for dynamis based on a measure.

 

I tried to add a calculated column which can diplay another column of the same table depending of a value: Value 1 will disply column A, Value 2 will display column B,....

The Value is determined by a measure based on a table not linked to the previous one.

 

Tables look like:

Column AColumn BColumn CSWITCH
abc 
aabbcc 
aaabbbccc 

 

Selection
1
2
3

 

So if I select 1 from the Selection Table, then the SWITCH column from the other table will diplay column A.

 

Value is determined by the following measure:

- Measure = MIN('Selection'[Selection])

SWITCH column is as below:

- SWITCH = SWITCH([Measure];1;[Column A];B;;[Column B];C;;[Column C])

 

But when I tried to use in a visual I always get Column A in SWITCH whatever is selected in Measure.

See below an example: we see Measure = 2 & I should see the column B values. But instead I always got the column A

 

Do you know what is wrong with the Switch function ?

Thanks

Need Help

2 Replies

    • PHDurand's avatar
      PHDurand
      Helper I
      7 years ago

      Actually I already tried to built it as a measure. The problem is that the measures are added in visuals. As I want to keep the result as a distinct value (no aggregation) I was trying to built it as a custom column.

      Is there any option "don't summarize" to apply on measures ? Or any way to change the formulas & make sure all resulta are distincts ?

       

      Thanks