Show data that could not be matched

[ManonNL]

I have established a many to one relationship between fact table A (many) and dimension table B (one), bidirectional.  I want to see in one table which values ​​occurred in both and are therefore linked. That works, because it shows the values of the relation. But I also want one table with the values ​​from dimension table B that could not be linked with the values in table A.  Without using power query, with which dax formula can I see these values?

[DOLEARY85]

Hi 

you could create a calculated table using:

Table = FILTER('Dimension Table',NOT(CONTAINS('Fact Table','Fact Table'[ID Field],'Dimension Table'[ID Field])))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍