topic Filter names not cited in another table in DAX Commands and Tips

Filter names not cited in another table

FabianoJohann — Tue, 14 Mar 2023 22:24:22 GMT

I Have 2 Tables:

Table 1:
Column1: Name (with 5 names: Adam, Frank, Thomas, Julie, Simon)

Table 2:
Column1: Name
Column2: Partner
2 Lines: column Name (Adam, Adam), columns Partner (Frank, Thomas)

In Dashboard i have 1 segmentation (Column1 Table1)

I need a table visual that contains:
All column1/table1 names that were not mentioned in column2/table2 when I filter the name in the segmentation.

Example:
Segmentation: Adam
Result: Julie, Simon

Re: Filter names not cited in another table

amitchandak — Wed, 15 Mar 2023 02:52:32 GMT

FabianoJohann , if you have a common dimension name, then measure can help

With common name dim

Countx(Except(Table1[Name], Table2[Partner]), [Name])

Plot with common name dim joined with name of table 1 and Partner of table 2

Or create a new table

Except(Table1[Name], Table2[Partner])

Re: Filter names not cited in another table

FabianoJohann — Wed, 15 Mar 2023 15:25:24 GMT

I couldn't, let's try another way.

by power query, I'll give an example of the tables:

Table 1

Name

Adam

Frank

Thomas

I need an M formula to add a second column that repeats all the names for each name in column 1 except itself, so it looks like this:

Name	Partner
Adam	Frank
Adam	Thomas
Frank	Adam
Frank	Thomas
Thomas	Adam
Thomas	Frank