IF statement between two tables new column

[Anonymous]

Hi everyone, 

I have two tables and I am trying to match the product on the quote table to the product on the item database table and if they match put in a value from the item database table in a new column. My measure is as follows:

ItemMasterVS = 
VAR _part = 'Quote Report 24'[Quote Product]
return 
IF(
    CALCULATE(
        COUNTROWS('Item Master'),
        FILTER(
            ALL('Item Master'), 
            _part = 'Item Master'[Product])), 
            RELATED('Item Master'[VS]),
            "Not in ?")

Some of the "VS" values are being inputted, but many of them are coming up blank or "Not in ?". The blanks are 100% in both tables, but not reading the "VS" while the ones coming up as "Not in ?" are not in either sheet. Is it because of the RELATED function I am using?

Any help would be appreciated!

[Anonymous]

It has something to do with my relationship model. I created an index on the item database sheet as a many-to-many relationship issue occurs. 

[v-kkf-msft]

Hi @Anonymous ,

Has your problem been solved? If it is solved, please accept your reply as the solution to help the other members find it more quickly.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz