Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
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"
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"
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |