Unable to create new calculated column using a lookup value column

[VonMurray]

Hello All, 

I'm not sure if this is a glitch or if I'm doing something wrong. I've done this plenty of times in the past but it is not working now.

I have two calculated columns using the LOOKUPVALUE function to bring data back from other tables. Both have direct relationships.

I want to create a calculated column to add the two values together.

As soon as I hit enter, the formula dissapears.  No error messages appear.

It does this with any formula I tie to a calculated column using the LOOKUPVALUE function.

Do you know if this is a glitch or am I doing something wrong?

[VonMurray]

Thank you all very much.  One of my data tables had duplicates and blanks; I cleaned that up. That allowed the RELATED function to work.

[danextian · Accepted solution]

Hi @VonMurray 

If there's a direct relationship between the two tables, use RELATED function on the many side of the relationship to access the value from the one side.

[Ashish_Mathur]

That is strange.  Share the download link of the PBI file.

[lbendlin]

If there are relationships then use RELATED. If there are no relationships, use TREATAS.  LOOKUPVALUE should only be used if really, really nothing else works.