Forum Discussion

Avivek's avatar
Avivek
Post Partisan
3 years ago
Solved

Need help with IF Dax

I need to create a dax with 2 conditions, I am able to add one condition but not both. I need the dax to be something like this- Measure 2 = SWITCH((SELECTEDVALUE(Sales[System Id]),"TX-300.301"...
Need Help
Show and Tell
  • rsbin's avatar
    rsbin
    3 years ago

    Avivek ,

    I think the issue is the syntax.  Please try this:

    Measure 2 = SWITCH(
                TRUE(),
           AND(SELECTEDVALUE(Sales[System Id])="TX-300.301",
               SELECTEDVALUE(Division[Division Id])= "100800"), 1,
               0)

     Is your Division ID a text value or numeric?  In your Measure, the fact that you put in "", I am assuming this field is text.  If not, then remove the quotation marks.

    Hope this gets you sorted out.

    Regards,

rsbin's avatar
rsbin
Community Champion
3 years ago

Avivek ,

I think the issue is the syntax.  Please try this:

Measure 2 = SWITCH(
                TRUE(),
           AND(SELECTEDVALUE(Sales[System Id])="TX-300.301",
               SELECTEDVALUE(Division[Division Id])= "100800"), 1,
               0)

 Is your Division ID a text value or numeric?  In your Measure, the fact that you put in "", I am assuming this field is text.  If not, then remove the quotation marks.

Hope this gets you sorted out.

Regards,