Need help with IF Dax

Question

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") || SELECTEDVALUE(Division[Division Id]= "100800", &nbsp;1,0))

&nbsp;

But I am able to add only one condition at a time.I also tried&nbsp;

Measure 2 = IF(SELECTEDVALUE(Sales[System Id]),"TX-300.301" &amp;&amp; SELECTEDVALUE(Sales[Division Id],"1008800.00"),1)

But this doesn't work.
Can someone please let me know where I am making the mistake and what would be the right DAX?

rsbin · Accepted Answer

Avivek ,
I think the issue is the syntax.&nbsp; Please try this:
Measure 2 = SWITCH(
                TRUE(),
           AND(SELECTEDVALUE(Sales[System Id])="TX-300.301",
               SELECTEDVALUE(Division[Division Id])= "100800"), 1,
               0)
&nbsp;Is your Division ID a text value or numeric?&nbsp; In your Measure, the fact that you put in "", I am assuming this field is text.&nbsp; If not, then remove the quotation marks.
Hope this gets you sorted out.
Regards,

Forum Discussion

Need help with IF Dax

1 Reply