Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Return multiple values from related table, using slicer selection

Hello,   This sounds basic, but could not get to a proper solution, so a little help is appreciated.   Basically, a value is selected on a slicer and then single or multiple values should be retu...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    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)
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample output in table format?
Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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)
    )

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi , 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