If not, result error

[Anonymous]

The formula used is given in the screenshot. If length, width, height >0 then "YES" plus "No"

Els

[calerof]

@Anonymous 

Are you using Width or Weight?

F

[Anonymous]

@calerof width

[calerof]

@Anonymous 

You're not showing the Width column in your screen-shot. It'd be helpful if you share a sample of your data.

F

[Anonymous]

@calerof plz take a look

[calerof · Accepted solution]

Hello @sbhan4 ,

Try this:

GPPCheck = 
SWITCH(
    TRUE(),
    SUM(GPP[Height]) <=  0 ||
    SUM(GPP[Lenght]) <= 0 ||
    SUM(GPP[Width]) <= 0,
    "No",
    "Yes"
)

I hope it helps.

Best regards

Fernando

If it helped, please consider liking the post and mark it in response.

[Anonymous]

@calerof Hello sir,

I tried your solution. Everything showing "YES" only. As you see in the screenshot, 

if any of the column value is 0 or blank = NO

Each column has a value >0 then only YES. can you share your pbix file.

[calerof]

Hi @Anonymous ,

You are doing it the opposite way, and that's fine. You just have to change the OR for AND.

Cheers,

Fernando

[calerof]

[Anonymous]

@calerof

Hi,

I tried that too. The first row should be NO. Everything is coming YES.

[calerof]

What is your code for GGP now?

[Anonymous]

Hi,

As you can see in the screenshot, the code is the same as you told. Now I changed || to &&.

[calerof]

Please provide a sample of your data with your pbix file to help you.

F

[Anonymous]

@calerof It's working now. Great help!

[Anonymous]

@calerof I have updated the screenshot with a width column. Please help me with that.