topic Re: Switch statement with fields and not measures in DAX Commands and Tips

Switch statement with fields and not measures

adinh1 — Tue, 05 Sep 2023 19:35:06 GMT

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])

Re: Switch statement with fields and not measures

DataNinja777 — Tue, 05 Sep 2023 21:12:40 GMT

Hi adinh1

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

Re: Switch statement with fields and not measures

adinh1 — Wed, 06 Sep 2023 15:39:34 GMT

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

Re: Switch statement with fields and not measures

DataNinja777 — Wed, 06 Sep 2023 20:32:33 GMT

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?

Re: Switch statement with fields and not measures

adinh1 — Wed, 06 Sep 2023 21:48:01 GMT

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.