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
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.  

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

      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". 

      • RobertSlattery's avatar
        RobertSlattery
        Icon for Responsive Resident rankResponsive Resident
        8 years ago

        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.