cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

If not, result error

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

Els

sbhan4_0-1601341558350.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Supplier
Solution Supplier

Re: If not, result error

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.

View solution in original post

14 REPLIES 14
Highlighted
Solution Supplier
Solution Supplier

Re: If else result error

@sbhan4 

Are you using Width or Weight?

F

Highlighted
Helper V
Helper V

Re: If else result error

@calerof width

 

Highlighted
Solution Supplier
Solution Supplier

Re: If else result error

@sbhan4 

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

F

 

Highlighted
Helper V
Helper V

Re: If else result error

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

Highlighted
Helper V
Helper V

Re: If not, result error

@calerof plz take a look

sbhan4_0-1601342116140.png

Highlighted
Solution Supplier
Solution Supplier

Re: If not, result error

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.

View solution in original post

Highlighted
Helper V
Helper V

Re: If not, result error

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

 

sbhan4_2-1601586777465.png

 

 

sbhan4_1-1601585710392.png

 

 

Highlighted
Solution Supplier
Solution Supplier

Re: If not, result error

Hi @sbhan4 ,

 

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

 

Cheers,

Fernando

Highlighted
Solution Supplier
Solution Supplier

Re: If not, result error

and.png

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors