Forum Discussion
Exclude order numbers not containing a specific article
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?
Issue is solved. Fixed this by filtering in another table.
2 Replies
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-Forum/ba-p/963216
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/1447523Issue is solved. Fixed this by filtering in another table.
