How to create table visualisation of unmapped items

[Anonymous]

Hi,

I have uploaded a test Power BI file to https://ufile.io/tw3of

I have two tables: "Car" and "Wheel Sizes", and I need to create a table visualisation listing the cars that do not have a mapping to the "Wheel Sizes" table. Pleaes can you help me create the table visualisation? (I know how to filter a table by 'blank' items, but don't know how to show completely unmapped items)

Mapping:

Input tables:

Current table visualisation (it is wrong, it should output the cars with no mapping to wheel size: "BMW" and "Mazda"):

Thank you for your help,

CM

[Anonymous · Accepted solution]

The fix was to "Don't Summarize" the "Wheel Size" field, then to filter "Wheel Size" by blanks.