Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Anonymous
Not applicable

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"
||'Incident Data'[Support Group] = "Orange"
&& not(CONTAINSSTRING('Incident Data'[Template],"Banana"||"Grapes")), "Group A"
,IF('Incident Data'[Support Group] = "Cucumber"
||'Incident Data'[Support Group] = "Tomatoe"
||'Incident Data'[Support Group] = "Broccoli"
&& (CONTAINSSTRING('Incident Data'[Template], "Banana"||"Grapes")),"Group B"))
 
Any ideas?
 
3 REPLIES 3
bsheffer
Continued Contributor
Continued Contributor

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

Anonymous
Not applicable

Yes, it is Text

 

gabbyl03_0-1677796058428.png

 

bsheffer
Continued Contributor
Continued Contributor

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.