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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for the responses!  I thought that may be the answer, which is unfortunate since it is a live connect and I cannot manipulate the data...