Forum Discussion

yanivshe's avatar
yanivshe
Icon for Helper I rankHelper I
6 years ago
Solved

Lookupvalue function returning BLANK

Hi all,   I am breaking my head over this one... I have 2 table with products and their test results: Table "PRODUCTS": contains products and metadata and test results PRODUCT_LINE ... TEST...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi  yanivshe ,

     

    Is there multiple rows have the same value in the column "Child"?If so,you'd better use relatedtable() instead of lookupvalue() and you need to create a calculated column as below:

     

     

    Column = 
var a= CALCULATE(MAX('Table'[TEST_RESULT]),FILTER(RELATEDTABLE('Table'),'Table (2)'[CHILD]='Table'[PRODUCT_LINE]))
Return
'Table (2)'[QTY]*a

     

     

    Finally,you will see:

     

    For the related .pbix file,pls click here.

     

     
    Best Regards,
    Kelly
     
    Did I answer your question? Mark my post as a solution!

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

See my file here. Your calculated column seems to work for me as shown below, correct? It may be your relationship isn't set up correctly. See the model in my file and ensure yours is the same.