Switch statement with fields and not measures

Question

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 · Answer

Hi&nbsp;adinh1&nbsp;Something like below (depending on the field names in your data model) should work.&nbsp;&nbsp;&nbsp;

adinh1 · Answer

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

dataninja777 · Answer

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

adinh1 · Answer

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.

Forum Discussion

Switch statement with fields and not measures

4 Replies

Related content

Switch statement in power query

PowerBI measure IF statement

Nested switch statements?

IF Statement or Switch

Switch Statement Not Working