cancel
Showing results for
Did you mean:
Member

## Indicate if 1 row is > 0

Hello,

I am working on a report for production orders which has an indicator if the quantities of the BOM items are available in the warehouse.

So far I've managed to gather the data I need and visualize it like this:

Which is pretty awesome and informative, but I don't want to have the [BOM Item] in the table and also I would like to have only 1 row per Production order like this:

So what I'm trying to achieve here is to have a measure that indicates 0 (or false or whatever) when there is even 1 row for the given production order in which [Available - required] < 0.

In English it's somethink like: "If the measure [Available - required] for any of the rows for a distinct production order is less than 0, then requirement is not met, else the requirement is met."

I hope this is interesting for you to solve.

1 ACCEPTED SOLUTION

Accepted Solutions
Member

## Re: Indicate if 1 row is > 0

Hello jthomson,

Thank you for your suggestion.
Doing what you say won't solve it by itslef. But actually that gave me a pretty nice idea. How to solve it very simply.

Use an if statement then while aggregating on production order level set the column to show min. If the min value for the lines of a given production order is 0 then there is an item with missing quantity.

2 REPLIES 2
Highlighted
New Contributor

## Re: Indicate if 1 row is > 0

Should be easy enough for you to do either in Power Query or as a calculated column, basically exactly as you suggest (if negative then 1 else 0) - Power Query's probably tidier to do so and it should walk you through it easily enough

Member

## Re: Indicate if 1 row is > 0

Hello jthomson,

Thank you for your suggestion.
Doing what you say won't solve it by itslef. But actually that gave me a pretty nice idea. How to solve it very simply.

Use an if statement then while aggregating on production order level set the column to show min. If the min value for the lines of a given production order is 0 then there is an item with missing quantity.

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

#### PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 102 members 1,568 guests
Recent signins: