Forum Discussion
Switch statement with fields and not measures
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], 'Tabl...
DataNinja777
Super User
Super UserHi 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?
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.