Show Data when Date from other Table shows blank

[rshifflet]

I have two tables.

Table 1contains a full list of equipment numbers from our database.

Table 2 contains a list of equipment numbers and the dates they were inspected from a SharePoint list.

I can create a simple view using Table 2 that shows the date range, and equipment numbers inspected (see below).

However, I need an additional list right next to the "INSPECTIONS BY AUTHOR" that shows the equipment numbers that were NOT inspected during the same date range. Essentialy it would be one that compares the equipment numbers in Table 2 against the full list of equipment numbers in table 1, and show me what's remaining from table 1.

I have tried multiple approaches to this, however I haven't found a workable solution yet. 

[Greg_Deckler]

Hard to tell from what you posted but maybe an Inverse Selector or complex selector?

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325

Complex selector is attached below.

Could probably help more if you did this: Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490