Forum Discussion

adinh1's avatar
adinh1
Regular Visitor
3 years ago

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's avatar
DataNinja777
Icon for Super User rankSuper User
3 years ago

Hi adinh1 

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

 

  • adinh1's avatar
    adinh1
    Regular Visitor
    3 years ago

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

    • DataNinja777's avatar
      DataNinja777
      Icon for Super User rankSuper User
      3 years ago

      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's avatar
        adinh1
        Regular Visitor
        3 years ago

        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.