Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to return multiple values separated by commas (DAX)

Hi, everyone. I suppose that it is noobie question - but I can't find an answer. Pls, help. I have 2 tables and need to create a new one The first table contains Client ID and Source  The second ...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    You can create the following table:

     

    Table =
ADDCOLUMNS (
    SUMMARIZE ( FILTER ( Sold; Sold[Sold] = "YES" ); Sold[ClientID] );
    "Source"; CONCATENATEX ( RELATEDTABLE ( Source ); Source[Source]; ", " )
)

     

    If you want a measure you should use:

    Measure = CONCATENATEX(Source;Source[Source]; ", ")

    Then just filter out the Sold to yes on the filter of the visual.

     

     

amitchandak's avatar
amitchandak
Super User
6 years ago

Join both the tables on client id and use concatenatex on sold.table[source]

 

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax

 

all source =concatenatex(sold.table[source])

 

Display it in a table or matrix along with client id

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin