Sort(
Distinct(
AddColumns(
col_Event_Data_Collection,
DisplayTitle,
If(
IsBlank(Show_Name),
Title,
Title & " - " & Show_Name
)
),
DisplayTitle
),
Value
)
If(
IsBlank(Show_Name),
Sort(Distinct(col_Event_Data_Collection,Title),SortOrder.Ascending),
Sort(Distinct(col_Event_Data_Collection,Title &" - "& Show_Name),SortOrder.Ascending)
)