Return value from another table with one to many relationship within those two tables

Hi NoobAnalyst01,

To achieve your requirement, please try following method, see if it works for you:

DOMICILE =
CALCULATE (
    MAX ( ASSET_ATTRIBUTE[VALUE] ),
    FILTER (
        ASSET_ATTRIBUTE,
        ASSET_ATTRIBUTE[TYPE] = "REGION"
            && ASSET_ATTRIBUTE[ASSET_ID] = ASSET[ASSET_ID]
    )
)

Thanks,
Xi Jin.

Hi Jin,

Thanks,

this works for me.

the only question i have is why in my filter statement, i should include a asset_id=attrtibute_value.

becaue in my relationship, i alredy join those two tables together 1:m relationship.

but when I remove the a asset_id=attrtibute_value in my formula, it doen't work, just wonder is there any reason why we should include this?

Thanks

Frank