Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If not, result error

The formula used is given in the screenshot. If length, width, height >0 then "YES" plus "No" Els
Need Help
  • calerof's avatar
    calerof
    5 years ago

    Hello @sbhan4 ,

    Try this:

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

    gpp.png

    I hope it helps.

    Best regards

    Fernando

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

calerof's avatar
calerof
Icon for Impactful Individual rankImpactful Individual
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

@calerof plz take a look

sbhan4_0-1601342116140.png

  • calerof's avatar
    calerof
    Icon for Impactful Individual rankImpactful Individual
    5 years ago

    Hello @sbhan4 ,

    Try this:

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

    gpp.png

    I hope it helps.

    Best regards

    Fernando

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        calerof
        Icon for Impactful Individual rankImpactful Individual
        5 years ago

        Hi Anonymous ,

         

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

         

        Cheers,

        Fernando