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

Get Fabric certified for FREE! Don't miss your chance! Learn more

Reply
SkorpionAAM
Helper V
Helper V

Value error

I m geeting this error

text3 = if([Measure2:ضمن نطاق مشروع نيوم]>0, "يوجد عدد " &[Measure2:ضمن نطاق مشروع نيوم]& " تقع داخل نطاق مشروع نيوم","") || if([Measure2:Warnضمن نطاق مشروع نيوم] > 0, "يوجد عدد " & [Measure2:Warnضمن نطاق مشروع نيوم] & " تقع داخل نطاق مشروع نيوم","")


Capture.PNGAny one tell me where is the problem

 



2 REPLIES 2
amitchandak
Super User
Super User

@SkorpionAAM , You can not have OR between to if . so you merge them or combine conditions or use Switch true. They are two conditions return text

 

text3 = Switch (true() , [Measure2:ضمن نطاق مشروع نيوم]>0, "يوجد عدد " & [Measure2:ضمن نطاق مشروع نيوم] & " تقع داخل نطاق مشروع نيوم" , [Measure2:Warnضمن نطاق مشروع نيوم] > 0, "يوجد عدد " & [Measure2:Warnضمن نطاق مشروع نيوم] & " تقع داخل نطاق مشروع نيوم","")

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Same Error

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.