Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
@Mainer04401 , Try like
IF([State] in{"FL", "GA", "AL" ,"LA"}, [Measure 1], [Measure2])
if you need more help make me @
Appreciate your Kudos.
@Mainer04401 , Try like
IF([State] in{"FL", "GA", "AL" ,"LA"}, [Measure 1], [Measure2])
if you need more help make me @
Appreciate your Kudos.
@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?
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])
User | Count |
---|---|
141 | |
70 | |
69 | |
52 | |
52 |
User | Count |
---|---|
209 | |
92 | |
64 | |
60 | |
57 |