Exclude order numbers not containing a specific article

[Henrikwcarlsson]

In this example I would like to exclude all order numbers which not contain the article "A002 Legeringstillägg" (an alloy fee).

The first three order numbers are containing A002 (marked with green) and the ones marked with red do not - those are the ones I would like to exclude from the report. However I need the report to show all articles on the order numbers marked with green - not only A002.

Anyone knows how this can be achieved?

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Henrikwcarlsson · Accepted solution]

Issue is solved. Fixed this by filtering in another table.