how to get lookup value from another table

[dhanureddy9]

HI 

How can i use lookup value to get targets from another table?

[Anonymous · Accepted solution]

Hi @dhanureddy9 ,

You can create a calculated column as below in the table "Tab_calls":

Column = 
VAR _target =
    CALCULATE ( MIN ( 'Tab_Targets'[TARGET] ), 'Tab_Targets'[METRIC] = "AHT" )
RETURN
    'Tab_calls'[CALLS] * _target

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[Anonymous]

Hi,

without more information of the data I think you should look into using the LOOKUPVALUE function to create a new column  with the targets in it. That is assuming that there is a relationship between the tables? From there on, it is a matter of creater either a measure or another column with multiplication.
https://docs.microsoft.com/sv-se/dax/lookupvalue-function-dax