Forum Discussion
Dax - IF statement comparing two measures
I'm sure there is an obvious solution to this issue - it's awfully hard to google search for help with an if statement! I work for a consumer goods company - we sell items to customers at MSRP. ...
Order month is on my date dimension and works perfectly without my bad measure... Which us confusing.
Yes, DAX is always confusing when you're dealing with measures.
Did you try my suggestion with the relationships?
RobertSlattery - I had to get back to my work computer to try it... Unfortunately, I don't have SS 2016 - so I cannot set that as an option.
That being said... I think you're onto something...
I just changed the measure I need to be this:
Consumer Sales Type = IF(45=45,"Closeout Sales","Regular Sales")
And it still brought in all of my "garbage rows".
Based on your original post, it looks like your Consumer Sales Type is a calculated column rather than a measure. Can you confirm? It would also help if you published the exact code rather than pseudo code for the measures as well.