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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Mainer04401
Helper III
Helper III

IF [state] ="FL" or "GA", or "AL" or "LA" ...

I'm trying to write what I thought would be a simple expression but I'm stumped ...

I want to write an expression that returns one measure for stores in states specified and another measure for stores in states not specified.  For example, IF([State]="FL" or "GA" or "AL" or "LA", [Measure 1], [Measure2])

 

When I write the IF statement in a new measure, it appears that I can only evaluate measures and not dimensions like [State].  The other issue is how do I evaluate if the state column contains any of the states specified rather than just one state.  

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Mainer04401 , Try like

IF([State] in{"FL", "GA", "AL" ,"LA"}, [Measure 1], [Measure2])

if you need more help make me @

Appreciate your Kudos.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Mainer04401 , Try like

IF([State] in{"FL", "GA", "AL" ,"LA"}, [Measure 1], [Measure2])

if you need more help make me @

Appreciate your Kudos.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandakThank you but after I write If( the only fields I can enter are measures.  None of my columns (dimensions such as state) are showing up.  Do I need to write this expression in a column instead of a measure?

@Mainer04401 ,

one of two

IF(firstnonblank([State],blank()) in{"FL", "GA", "AL" ,"LA"}, [Measure 1], [Measure2])
IF(max([State]) in{"FL", "GA", "AL" ,"LA"}, [Measure 1], [Measure2])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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