cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Birdjo Member
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:
BOM lines.png

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:
po requirements.png

 

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! 

1 ACCEPTED SOLUTION

Accepted Solutions
Birdjo Member
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
jthomson New Contributor
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

Birdjo Member
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.


Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

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

Top Ideas
Users Online
Currently online: 102 members 1,568 guests
Please welcome our newest community members: