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. ...
Hi, what happens if you edit the relationship between the sales table and the date dimension and set your cross filter direction to "Both"?
Also, if it is a field in the sales table, it looks like there is something wrong with your [Order Month] field.
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".