Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
HI @eniX
In that case
Measure = VAR Myresult = CONCATENATEX ( LookUp, LookUp[value], ", " ) RETURN IF ( ISBLANK ( Myresult ), "", myresult )
How are you man?
What are your expected results?
Try this MEASURE
Measure = CONCATENATEX ( LookUp, LookUp[value], ", " )
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.
HI @eniX
In that case
Measure = VAR Myresult = CONCATENATEX ( LookUp, LookUp[value], ", " ) RETURN IF ( ISBLANK ( Myresult ), "", myresult )
Perfect, thank you again 🙂
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |