Forum Discussion

Zyg_D's avatar
Zyg_D
Icon for Continued Contributor rankContinued Contributor
5 years ago
Solved

Making the lookup work.

This is my data and model: let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRU0lECYTMzM6VYHaCAEVTA3NwcLGAE4oAELSwsIAJGUAFLS0ul2FgA", BinaryEncoding.Base64), Co...
Need Help
Show and Tell
Tips and Tricks
  • AntrikshSharma's avatar
    AntrikshSharma
    5 years ago

    Thanks BA_Pete 

     

    Zyg_D Does the following work for you?

    Column =
CALCULATE (
    MINX (
        Table1,
        RELATED ( Table3[AttributeData] )
    ),
    USERELATIONSHIP ( Table1[AttributeChild], Table3[Attribute] ),
    ALLEXCEPT ( Table1, Table1[AttributeChild] )
)
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
5 years ago

hi Zyg_D 

I don't think you need to create a relationship between table2 and table3, just remove this relationship and keep active for the relationship between table1 and table3.

 

or just use lookupvalue function to create a column as below:

Calculate Column = LOOKUPVALUE(Table3[AttributeData], Table3[Attribute], Table1[Attribute Child])

 

Regards,

Lin

  • Zyg_D's avatar
    Zyg_D
    Icon for Continued Contributor rankContinued Contributor
    5 years ago
    v-lili6-msft wrote:

    hi Zyg_D 

    I don't think you need to create a relationship between table2 and table3, just remove this relationship and keep active for the relationship between table1 and table3.

    or just use lookupvalue function to create a column as below:

     

    Calculate Column = LOOKUPVALUE(Table3[AttributeData], Table3[Attribute], Table1[Attribute Child])

     

    Regards,

    Lin

    Thanks, Lin (v-lili6-msft), for digging into the problem. the LOOKUPVALUE that you suggested is exactly like one of my tries which you can find above and which failed in my case. However, the suggestion to reorder my relationships may work too. I thought about it myself, it's just that I fear I would need to rework many things which are already dependent on these relationships.