Show count of records that DON'T MATCH in a relationship

[jdubs]

I have a relationship that matches addresses to a zip code table and then groups the row into a "zone" based on the the zip code. But I want to take any rows that fall out if this relationship and dump them into another "zone" and then show this count in a column graph.

e.g. Zones 1-8 would contain addresses which match the zip code table. Zone 9 would be any addresses which do not match and could be considered "out of market".

[jdubs]

In this same scenario how would I include the rows that don't match in a relationship in a table?

[FreemanZ]

hi @jdubs 

In your face table, try to add a tag column like this:

IsOutOfMarket =

IF(

    RELATED(ZipCodeTable[zone])=BLANK(),

    "YES", "NO"

)

then you can count the rows with "YES".

[Greg_Deckler]

@jdubs So like

Column = IF(COUNTROWS(RELATEDTABLE('Table'))=BLANK(),"Zone 9",...)