Perform one-to-many lookup with measure

[eniX]

Hi folks,

is it possible to perform a one-to-many lookup with measure, not calculated column? When I work with calculated columns and tables it's so intuitive, but with measures I just miss the row context...

simple example:

I have two tables with one-to-many relationship. Now I want to create a table visual and display id with values for choosen category.

I can't use LOOKUPVALUE properly because I can't say object.id = lookup.object_id.

Any ideas?

[Zubair_Muhammad]

@eniX

How are you man?

What are your expected results?

Try this MEASURE

Measure =
CONCATENATEX ( LookUp, LookUp[value], ", " )

[Zubair_Muhammad]

@eniX

[eniX]

trying to get used to DAX 🙂

your measure is nearly what I try to achieve, but I need a left join there instead of inner join. By this  I mean I need a full list of objects(id) no matter, if the measure is empty or not.  so in your example i also need to see ids 3,5 and 6 with an empty mesure each.

[Zubair_Muhammad · Accepted solution]

HI @eniX

In that case

Measure =
VAR Myresult =
    CONCATENATEX ( LookUp, LookUp[value], ", " )
RETURN
    IF ( ISBLANK ( Myresult ), "", myresult )

[Zubair_Muhammad]

@eniX

[eniX]

Perfect, thank you again 🙂