Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cannot convert string value of type text to True/False

I can't figure out why I am getting this error... "Cannot convert value 'Group B' of type Text to type True/False" in the example below:   Type = if('Incident Data'[Support Group] = "Apple" ||...
Need Help
bsheffer's avatar
bsheffer
Icon for Continued Contributor rankContinued Contributor
3 years ago

check the type of your measure or calculated field.  It needs to be text

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Yes, it is Text

 

 

  • bsheffer's avatar
    bsheffer
    Icon for Continued Contributor rankContinued Contributor
    3 years ago

    I don't see anything wrong with the type then.  However whenever you use both "ands" and "ors" you need to use parentheses to group the ors together.

     

    'Incident Data'[Support Group] = "Cucumber"
    ||'Incident Data'[Support Group] = "Tomatoe"
    ||'Incident Data'[Support Group] = "Broccoli"
    && (CONTAINSSTRING('Incident Data'[Template], "Banana"||"Grapes"))
     
    should be
    (
    'Incident Data'[Support Group] = "Cucumber"
    ||'Incident Data'[Support Group] = "Tomatoe"
    ||'Incident Data'[Support Group] = "Broccoli"
    )
    && (CONTAINSSTRING('Incident Data'[Template], "Banana"||"Grapes"))