Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Only aggregate distinct texts from different rows into the same column?

Hello everyone,   I am trying to aggreate texts from different rows to one column. Those texts from different rows are NOT unique.   An example is as below:   Order record table:       ...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can use the following measure in a table visual to meet your requirement:

     

    distinctAggregateMeasure =
CONCATENATEX ( DISTINCT ( 'Table'[Order_Product] ), [Order_Product], "," )

     

     

     Or we can just create a calculated table using following formula:

     

    AggregateTable =
SUMMARIZECOLUMNS (
    'Table'[Customer],
    "Text", CONCATENATEX ( DISTINCT ( 'Table'[Order_Product] ), [Order_Product], "," )
)

     

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
6 years ago

Please use concatenatex

 

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

 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Concatenatex-with-Distinct-column-values/td-p/89550

 

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 - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks for your answer too! It's sad that I can only select one solution!