Forum Discussion

loganwol's avatar
loganwol
Microsoft Employee
9 years ago
Solved

Concatenatex with Distinct column values

Hi, I am summarizing data from one table into another. Part of the data in the original table is a column of type text which I generate a comma delimited summary string.   Issues = var ft = ...
CONCATENATEX
DAX
bugs84's avatar
bugs84
Frequent Visitor
8 years ago

Hi all,

I'm looking for the same...

 

ListProductTypes = CONCATENATEX(Table;Table[ProductType];", ")

 

how can I get only distinct ProductType values?

  • AriSultani's avatar
    AriSultani
    Regular Visitor
    2 years ago

    Unfortunately, it does not work for me; I use the following code, and works perfectly.

    CONCATENATEX(DISTINCT(Table[The Column]),Table[The Column],", ")
  • zapppsr's avatar
    zapppsr
    Kudo Collector
    8 years ago

    Very good, thanks!

  • Zyg_D's avatar
    Zyg_D
    Continued Contributor
    6 years ago
    markdy wrote:

    Hey There bugs84,

     

    I think this might help:

     

    ListProductTypes = CALCULATE(CONCATENATEX(VALUES('Table'[ProductType]),'Table'[ProductType],","))

     

    Credit Goes to Data and Analytics with Dustin Ryan:

    https://sqldusty.com/2016/06/29/5-more-power-bi-tips/

     

    According to Dusting Ryan:

    Cited References:

    Dustin, Ryan. 5 More PowerBI Tips. Data and Analytics with Dustin Ryan, 2016. Web. 17 January 2018.

    This does not work in the OP's case

  • EduSurveys's avatar
    EduSurveys
    Advocate II
    6 years ago

    markdy , this solution works for me!