Lookup value from table with no relationship

[Lars Ole Sørensen]

Hi,

I need help in power bi to lookup a value from another table with no relationship to the model. I want to lookup the value in column "Bokført verdi (IB)" in the table "AvdelingDim" for the criteria "Fartøy" and "Type". In the sheet "OversiktPP" i have used excel formula to get the desires result (range I4:I7), but i want to accomplish this through powerbi measure.

Kindly Regards
Lars Ole

 

[Chihiro]

Something like below.

Bokført verdi IB :=
LOOKUPVALUE (
    AvdelingDim[Bokført verdi (IB)],
    AvdelingDim[Fartøy], FIRSTNONBLANK ( VALUES ( Aktivadata[Fartøy] ), 1 ),
    AvdelingDim[Type], FIRSTNONBLANK ( VALUES ( Aktivadata[Type] ), 1 )
)

 

[Lars Ole Sørensen]

Yes, the above reply from you Chihiro is what I want. Thank you very much for the help