Indicate if 1 row is > 0

[Birdjo]

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.

Thanks in advance! 

[jthomson]

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

[Birdjo · Accepted solution]

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.