Measure to list customers who are in query A but not in query B

[EVEAdmin]

Hi all,

I built a report with the tables displayed in the screen shot below.
The table HostedDBs provides the list of all customers: 67
The table Tickets provides the list of customer using a feature: 46

Using another measure as sort of template, I generated this measure. The measure returns Blank instead of 21

Any suggestion on what to do to fix it, please?

ZeroSender = 
var AllStores = DISTINCT(HostedDBs[HDEveCustID])
var ActiveStores = DISTINCT(Tickets[TkCustID])
var NonActiveStores = EXCEPT(AllStores,ActiveStores)
return
IF(HASONEVALUE(HostedDBs[HDEveCustID])
    ,IF(FIRSTNONBLANK(HostedDBs[HDEveCustID],0) in NonActiveStores, 1 , BLANK())
    ,BLANK()
)

[EVEAdmin · Accepted solution]

l solved this situation with a different approach.

I created a Merged Table, with Left Anti (Rows only in the first table) Join option. It works a treat.