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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.