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.
