Forum Discussion

Zyg_D's avatar
Zyg_D
Continued 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] )
)
PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

Zyg_D 

For a measure, try:

 

 

Measure = CALCULATE(MAX(table3[AttributeData]), TREATAS(VALUES(table1[AttributeChild]), table3[Attribute])

 

If you prefer a calculated column for table1:

 

 

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

 

 

 

 

Btw, why do you need a two-directional cross filtering in many-to-one relationships?

 

Tahreem24's avatar
Tahreem24
Super User
5 years ago

Zyg_D ,

Below is the  screen shot only based on relationship.

Step 1: Create the relationship like below screen shot.

Step 2: Directly take all columns from table 1 and simply take AttributeData from Table3. (refer screen shot 2).

Step 3: If you want to achieve using a dax so write column : CALCULATE(MAX(Table3[AttributeData])). (Refer screen shot 3).

 

1 (Relationship)23 (DAX Column)