Filtering help

[MagnusLarsson94]

Hey,

Might be a simple question but can't seem to get it right.

I have two sql Queries including measurement of products and orderlines.

I need to filter out the orders with a specific measurement.

Example:

Order: XXX

Product: A = Ok
Product: B = Too big 

Action: Don't Show Order XXX

As for now I've only figured out how to filter the products per say but seeing as an order can have a both accepted and not accepted product I need to filter so that if an order have "Not allowed product" it shouldn't be counted even if it has products on it that's fine. 

[v-jayw-msft]

Hi @MagnusLarsson94 ,

What's the relationship between Order and Product? Can you show some sample data?

How-to-Get-Your-Question-Answered-Quickly .

Best Regards,

Jay

[amitchandak]

@MagnusLarsson94 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[MagnusLarsson94]

Yea, might have been abit of on my explanation.

Basically:

We're in the need of filtering all orders from last year - sold on a specific channel, get the CBM of the orders and exclude orders with products that have a height larger than "Numeric Value 14".

Added Column to make it somewhat clearer:

Yes = Product with numeric value lower than 14

No = Product with numeric value higher than 14

If the order Contains Yes = Show

If the order Contains Yes & No = Don't Show

If the order Contains No = Don't Show.

Orders usually have 3+ products meaning that more often than not they have 2-3 numeric values (1 per product). If just one of these producs have the numeric value of higher than 14 => Don't show the order. 

Added a picture as following:

Hope this makes it somewhat easier to understand - Thanks.