Forum Discussion
Return multiple values from related table, using slicer selection
Thanks for asking, I actually did realize what I was doing wrong, I just had to stop and return to it, nevertheless, thanks for being helpful!
I was just trying to return multiple values on a card from a related table, based on a slicer selection.
In the end I used concatenatex, wrapped in a calculate, where I FILTER the table, using a variable for the currently selected value of the ID.
Measure =
VAR MyID=
SELECTEDVALUE ( ID)
RETURN
CALCULATE (
CONCATENATEX ( VALUES ( dPort), dPort[Discharge Port], ", " ),
FILTER ( 'ShipRoutes', 'ShipRoutes'[ID] = MyID)
)
Thanks for asking, I actually did realize what I was doing wrong, I just had to stop and return to it, nevertheless, thanks for being helpful!
I was just trying to return multiple values on a card from a related table, based on a slicer selection.
In the end I used concatenatex, wrapped in a calculate, where I FILTER the table, using a variable for the currently selected value of the ID.
Measure =
VAR MyID=
SELECTEDVALUE ( ID)
RETURN
CALCULATE (
CONCATENATEX ( VALUES ( dPort), dPort[Discharge Port], ", " ),
FILTER ( 'ShipRoutes', 'ShipRoutes'[ID] = MyID)
)
Community SupportHi , Anonymous
Could you please tell me whether your problem has been solved?
If it is, please mark the helpful replies or add your reply as Answered to close this thread.
More people will learn new things here. If you haven't, please feel free to ask.
Best Regards,
Community Support Team _ Eason