Find codes not showing in other related tables

[Jo_Chrq]

Hi all,

I have an Article Table joined with a Sales Table and a Stock Table (joined on ArticleCodes).

I want to isolate all the article codes that are not showing in the sales table nor in the stock table (never sold / never in stock).

I hope I was clear.

Many thanks in advance

jo

[Greg_Deckler]

@Jo_Chrq Maybe:

Table = FILTER('Articles', RELATEDTABLE('Sales') = BLANK() && RELATEDTABLE('Stock') = BLANK() )

or maybe:

Table = 
  VAR __Articles = 'Articles'
  VAR __SalesStock = 
    UNION(
      SELECTCOLUMNS('Sales', "__Article", [ArticleCodes])
      SELECTCOLUMNS('Sales', "__Article", [ArticleCodes])
    )
  VAR __Table = FILTER( __Articles, [ArticleCodes] NOT IN __SalesStock )
RETURN
  __Table