Forum Discussion

Wadi-Luca's avatar
Wadi-Luca
Frequent Visitor
5 years ago
Solved

lookupvalue error

Hello all, I am having alot of trouble with the lookupvalue function in power bi. I am trying to get a specific result column into a different data page, but the error about 'multiple values selecte...
  • Fowmy's avatar
    Fowmy
    5 years ago


    Wadi-Luca 

    You can use the RELATED function as a new column if you are on many side 

    new column = RELATED ( tblListFacilityType[credit_conv_factor] )


    if have multiple records and you are on the one side of the table:

    new column = MAXX ( RELATEDTABLE ( tblListFacilityType ), tblListFacilityType[credit_conv_factor] )



Fowmy's avatar
Fowmy
Super User
5 years ago


Wadi-Luca 

You can use the RELATED function as a new column if you are on many side 

new column = RELATED ( tblListFacilityType[credit_conv_factor] )


if have multiple records and you are on the one side of the table:

new column = MAXX ( RELATEDTABLE ( tblListFacilityType ), tblListFacilityType[credit_conv_factor] )