Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Avivek
Post Partisan
Post Partisan

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") || SELECTEDVALUE(Division[Division Id]= "100800",  1,0))
Avivek_0-1685632020487.png

 

But I am able to add only one condition at a time.I also tried 
Measure 2 = IF(SELECTEDVALUE(Sales[System Id]),"TX-300.301" && 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?
1 ACCEPTED SOLUTION
rsbin
Super User
Super User

@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,

View solution in original post

1 REPLY 1
rsbin
Super User
Super User

@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,

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors