Field Validation between 2 different Table
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.
