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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
wjkolesar
Advocate II
Advocate II

DAX - SWITCH TRUE Formula Not Producing Accurate Result

Trying to get a combination of two Dimensions returned where Is Active = Y and have Traffic In <> BLANK().  Used the SWITCH TRUE formula and where Traffic In = 0, I'm not getting the result returned.  I tried switching Traffic In >= 0 and that resloves, but breaks where Traffic In is NULL (or blank).  Any ideas?  Thanks!SWITCHTRUE.PNG

 

1 ACCEPTED SOLUTION
wjkolesar
Advocate II
Advocate II

Nevermind - I got it.  For those curious, I changed the AND statement to the bleow (I added NOT(ISBLANK)).

 

AND(NOT(ISBLANK([Traffic In])) <> BLANK(),[Is Active]= "Y"

View solution in original post

1 REPLY 1
wjkolesar
Advocate II
Advocate II

Nevermind - I got it.  For those curious, I changed the AND statement to the bleow (I added NOT(ISBLANK)).

 

AND(NOT(ISBLANK([Traffic In])) <> BLANK(),[Is Active]= "Y"

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.