while using list of unique in custom measure, it automatically does an array_sort and also array_join with |record| upon it instead of plain aggregation. Have attached the screenshot of the generated SQL in data pane.