The function GetLinkedMember works well when you need to switch to another object. But it can’t switch to several other objects. You would like to use the function GetLinkedMembers instead.
The function getLinkedMembers will access a set of linked objects. Then you would like to apply some additional configurations to them:
- Show details per each object as a string:
NonEmptyString(Generate(
[Object].GetLinkedMembers('Desktop Displays'),
[Object].CurrentMember.Name || " - " ||
[Object].CurrentMember.GetString('Display Size')
, chr(10)
))
- Sum some numeric value from those objects.
NonZero(Sum(
[Object].GetLinkedMembers('Desktop Displays'),
[Object].CurrentMember.GetNumber('Display Size')
))
Here is my example for this. For each person, I have several competencies assigned. And each competence has some course costs. I represented the costs by course and the total sum of course costs.
Daina / support@eazybi.com