Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Lookupvalue Issue "Column Name Not Found" when adding Search Value 1

I have two tables:   1. A table that holds Quartiles by Different levels of a company (Company Location, Company Grouping, etc all in one column).   2. A table that holds the company hierarchy wi...
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    If you create a calculated column rather than a measure then the error will not appear.

    The reason is LOOKUPVALUE dax function returns a value fro every row, so you can't use it as a measure.

     

    Thanks,

    Pragati

wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

this function require the values must be identical exactly