Lookupvalue through a chain of relationships

[CarlsBerg999]

Hi,

My model is shown below. I have:

Active relationship from 1-2-4. This chain is 1-to-1 relationship

Active relationship from 1-3. This is 1-to-many relationship.

Inactive relationship from 3-4. This is 1-to-1 relationship

What I need to do, is a calculated column to Table 4. I need to use the inactive relationship (1-3-4) to fetch the values on a correct granularity level. I'm having issues figuring out the correct DAX for this. Can someone figure out the DAX formula to use the 1-3-4 chain to get values from table 1 to table 4?

[Jihwan_Kim]

Hi, @CarlsBerg999 

I am not sure if I understand your model correctly, but try to use LOOKUPVALUE function with RELATED function.

I hope it helps.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.

[CarlsBerg999 · Accepted solution]

I actually used a nested LOOKUPVALUE. Probably a poor solution but did the trick. I don't understand how related would have worked since there is no active relationship between 4 and 3.