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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
giovanni_figuei
Frequent Visitor

Two values in IF FALSE DAX

Hi im trying to put two values in the IF FALSE part of  the IF statement.

My situation requires that i show the "NOT OK" and a value from a column if the expression is false. I get the SINTAX ERROR with this code below.

giovanni_figuei_1-1642613754387.png

I dont even know if it is possible to do that but i will apreciate any help. Thank you for your time.

 

 

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@giovanni_figuei 

try to use "&" to connect.

"NOT OK" & 'EXAMPLE'[EXAMPLE]





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
ryan_mayu
Super User
Super User

@giovanni_figuei 

try to use "&" to connect.

"NOT OK" & 'EXAMPLE'[EXAMPLE]





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




amitchandak
Super User
Super User

@giovanni_figuei , What is that additional column doing

if(12>0, "OK" , "NOT OK")

 

Use Switch for multiple  conditions

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors