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.
var ft = FILTER(RELATEDTABLE(Data),
[ID] = Data[ID] && Data[Result] <> "Pass" &&
var issuessummary = CONCATENATEX(ft, Data[Issue], ",")
This works perfectly but I realized that the return values can be duplicate, so a result value string for issuessummary could equal "ABC", "DEF", "ABC", "xyz". I would like to remove the duplicate in the return string to represent "ABC", "DEF", "xyz".