Switch statement with fields and not measures

[adinh1]

Hi, I am trying to create a switch statement using table fields and and not measaures.

Something like:

Category = 
SWITCH(SelectedValue('Table A'[Category] = "Red"),
'Table A'[RedItems], 'Table A'[OtherItems])

[DataNinja777]

Hi @adinh1 

Something like below (depending on the field names in your data model) should work.  

[adinh1]

Hi Sakiko, thanks for the help, but the problem is that Reditems and Otheritems are actually fields within the same table. (Table A)

[DataNinja777]

Hi @adinh1 

Are Reditems and Otheritems mutually exclusive (i.e., there are no overlaps)?  In that case, why do you need to separate those out in two columns and not combine in one field?  

[adinh1]

Other items has values that is diff than red items in my case and we want to display both the unique values. For example Red needs to show it's own and Others need to show theirs.