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

## If not, result error

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

Els

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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"
)``````

I hope it helps.

Best regards

Fernando

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

14 REPLIES 14
Highlighted
Solution Supplier

## Re: If else result error

Are you using Width or Weight?

F

Highlighted
Helper V

## Re: If else result error

@calerof width

Highlighted
Solution Supplier

## Re: If else result error

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

## Re: If else result error

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

Highlighted
Helper V

## Re: If not, result error

@calerof plz take a look

Highlighted
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"
)``````

I hope it helps.

Best regards

Fernando

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

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

Highlighted
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

## Helpful resources

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

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

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### 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