Forum Discussion

KellyDittmar's avatar
KellyDittmar
Icon for Advocate IV rankAdvocate IV
8 years ago

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. ...
Need Help
RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
8 years ago

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.

  • KellyDittmar's avatar
    KellyDittmar
    Icon for Advocate IV rankAdvocate IV
    8 years ago
    Order month is on my date dimension and works perfectly without my bad measure... Which us confusing.
    • RobertSlattery's avatar
      RobertSlattery
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

      Yes, DAX is always confusing when you're dealing with measures.

       

      Did you try my suggestion with the relationships?

      • KellyDittmar's avatar
        KellyDittmar
        Icon for Advocate IV rankAdvocate IV
        8 years ago

        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.