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] )
)
AntrikshSharma's avatar
AntrikshSharma
Community Champion
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] )
)
  • Zyg_D's avatar
    Zyg_D
    Continued Contributor
    5 years ago
    AntrikshSharma wrote:

    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] )
)

     

    AntrikshSharma  - You are the true Power BI hero, man! Many superusers and Microsoft staff failed... and you did it! It's increadible! Too bad that I can only give one thumb up 🙂 Cheers!