switch programming

[reynold522]

Hi all,

Capacitythreshold =

SWITCH (TRUE(),

'table'[REGION] = "US", 'table'[CAPACITY_AH]*200*4,

'table'[REGION] = "EU"&&'table'[BAT_TYPE]="1",'table'[CAPACITY_AH]*200,

'table'[REGION] = "EU"&&'table'[BAT_TYPE]="2", 'table'[CAPACITY_AH]*150,

table'[REGION] = "EU"&&'table'[BAT_TYPE]="3", 'table'[CAPACITY_AH]*100,

BLANK())

I implemented above code, if I modify the red colour part to a constant number, e.g., I replace 'table'[CAPACITY_AH]*200*4 with 800 this code will work.

However, I would like to keep is as a calculated value base on table. 

How can I modify the code to make it work?

Thanks in advance. 

Best regards

[djurecicK2]

Are you creating a measure or calculated column? For measure, You have to do an aggregation on the field like SUM, etc. 

[djurecicK2]

Hi @reynold522 ,

 I would try creating measures for each of those values in red and using those measures in the SWITCH statement.