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

[Tangi12]

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 with the Company Location column, Company Grouping in separate columns.

I wanted to create a DAX measure that looks up the quartile value based on Company Location.  I created the measure as the below, but the bold column is getting an error stating the column name cannot be found. Both columns are text that are being compared. Both columns have matching data.  

What am I doing wrong?

Quartile by YoY = Lookupvalue('PPR Quartiles'[Quartile1],'PPR Quartiles'[Geo ID],'Company Hierarchy'[Company Location])

[Tangi12]

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...

[wdx223_Daniel]

this function require the values must be identical exactly

[Pragati11 · Accepted solution]

Hi @Tangi12 ,

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