Forum Discussion

yanivshe's avatar
yanivshe
Helper 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!

     

v-kelly-msft's avatar
v-kelly-msft
Community Support
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!