Forum Discussion

Unknown_1's avatar
Unknown_1
Frequent Visitor
2 years ago
Solved

Need help on Lookupvalue dax

Hi Team,   I have a dataset of 3 columns a   s stated in the picture attached. I want to do a simple vlookup of the second column in the entire range and want to return the result(Third co...
Need Help
  • jgeddes's avatar
    jgeddes
    2 years ago

    Yes, blank rows will also cause that issue with LOOKUPVALUE.
    You can try something like...

    Calculated Column 2 = 
var _vTable =
SUMMARIZE(
    'Table',
    'Table'[Column1],
    "_value", SUM('Table'[Column3])
)
var _result =
SUMX(
    Filter(_vTable, [Column2] = [Column1]),
    [_value]
)
Return
_result

    Let me know how that works.

jgeddes's avatar
jgeddes
Super User
2 years ago

Using the example table...

Column1 Column2 Column3
AAA-BBB AAA-BBB 100
ABC-DEF ABC-FED 50
ABA-AAA ACA-AAA 75
DAC-FED DAC-FED 250

 

You can use a calculated column...

Calculated Column = 
LOOKUPVALUE('Table'[Column3],'Table'[Column1],[Column2])

 

To get the result...

 

Unknown_1's avatar
Unknown_1
Frequent Visitor
2 years ago

By doing this it's giving me the error " A table of multiple values was supplied where a single value was expected"