Field Validation between 2 different Table

[KevinMorneault]

Hi 

I am trying to find a way to validate some data within 2 Table. Relationship setup are Many to Many Both .

The purpose of this is to validate most of the data between 2 table. 

1. First I want to validate Serial from both Table. 

       a) Table 1   SCCM

       b) Table 2   Asset Management

    I wrote a query which does the validation and provide an outpout of Found or NotFound

    The query use is something like this 

     IF(LookupValue('AssetManagement'[SerialNumber],     'AssetManagement'[SerialNumber],'SCCM[SerialNumber'='SCCM[SerialNumber],"Found","NotFound")

     Output result works by providing which one are Found and NotFound. 

      The issue is I created a detailed view (Visual) by including SCCM Serial, SCCM Serial Validation, this works fine, but if i

       add a colum from AssetManagement to this visual,  Exmaple Organisation, OrganisationValidation, it works with the Found

       but does not work with NotFound, it just remain blank. If I remove colum from Asset Management it works.

 Is there a way to make this work, and it woud say NotFound for either serial or Organisation if it's not found.

[KevinMorneault]

Hi

I found the issue and it is now working. Basically in the Colum under visualization, needed to select 'Show items with no data'