Measure - Concatenax(values)

[Anonymous]

Hi, I would like to concate the distinct value from one column.

CONCATENATEX(
    VALUES(Table1[Name]), 
    Table1[Name],
     "," )

There is also a "Date" column on table1, however, when I try to use the "Date" slicer, the measure will show blank.

May I ask how to fix?

Thanks

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please have a try.

Create a measure.

Measure = var _maxdate=MAXX((ALLSELECTED('Table')),'Table'[date])
var _mindate=MINX(ALLSELECTED('Table'),'Table'[date])
return
CONCATENATEX(FILTER(ALL('Table'),'Table'[date]<=_maxdate&&'Table'[date]>=_mindate),'Table'[name],",")

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FreemanZ]

hi  @Anonymous 

Do you also have a slicer or filter of any kind on the Name Column?

It seems two filter contexts are in confict.