Measure for concatenating values by ID

[felixthecat_nyc]

Hi all,

I have a custom column which has the desired output: 

CONCATENATEX(FILTER(SUMMARIZE(FlaggingLabor,FlaggingLabor[Date of Action],FlaggingLabor[Location]),[Date of Action]=EARLIER(FlaggingLabor[Date of Action])),[Location],", ")

This is basically a string concatenation by id. I need to use this value for a tooltip, but pbi will not let me drag the column into the tooltip. From what I've read, I basically need a measure that does the same thing my custom column does so I can use the measure for the tool tip. The 'id' is Date of Action and the rows to be concatenated are the Location field. If anyone knows how to transcribe the custom column into a measure that would be of great help. Thank you! 

[felixthecat_nyc]

@Greg_Deckler That worked, thank you for your time! 

[Greg_Deckler · Accepted solution]

@felixthecat_nyc Try:

Measure = 
  VAR __Date = MAX(FlaggingLabor[Date of Action])
RETURN
CONCATENATEX(FILTER(SUMMARIZE(FlaggingLabor,FlaggingLabor[Date of Action],FlaggingLabor[Location]),[Date of Action]=__Date),[Location],", ")