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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.